eazyBI - how to use count and filter function

Onur Cevik

Hey,

I am trying desperately to use count and filter function but I am failing. I would like to count the amount of cells which are green as you can see in the picture below and display the amount in the column Amount green status. My horizontal dimension is measures and my vertical issue and issue type. I hope someone can help me further. Thanks in advance.

Another question. How can I display values only in one row? Like values in the row of projectname? How to address one certain cell?

All the best,

Onur

Gerda Grantiņa _ eazyBI

Hi @Onur Cevik 
It does look that your current conditional formatting for green cells is based on "Ampeldarstellung Meilensteine < 3"?
If so, then you can count your green cells by creating a new calculated measure in Measure dimension and using this formula:

Sum(
Filter(
DescendantsSet([Issue].CurrentHierarchyMember, [Issue].[Issue]),
[Measures].[Ampeldarstellung Meilensteine] < 3
),
[Measures].[Issues created]
)

If you wish to reference only one row, you can use the CASE WHEN statement:

CASE WHEN
[Issue].CurrentHierarchyMember.Name = "YOUR PROJECT NAME"
THEN
--your formula goes in here
END

Best, 
Gerda // support@eazybi.com