How to create a card measure that would could count from a category based measure

[MuthalibAbdul]

So the MoM column gives the percentag increase oe decrease from previous month, while the percentage class is measure that categoires the row based on the the output in MoM column. I need to create 3 cards that shows how many showed increased trend, how many shows decreased, and how many showed no change.

I tried using the percentage class as filter but the filter is greyed out for some reason

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how your semantic model looks like, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

[Ashish_Mathur · Accepted solution]

Hi,

This measure should work

Measure = countrows(filter(values(Data[Product]),[MoM%new]>0)

[MuthalibAbdul]

This worked! thanks

[Ashish_Mathur]

You are welcome.

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how your semantic model looks like, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.