measure to count based on values of another measure

[Anonymous]

I'm new to Power Bi so bare with me as I try to explain my issue....

My dashboard deals with survey data.  I have positive, negative, and neutral scores for 88 questions.  I have created a Measure to calculate my Yearly Delta for each question so I can see if it's improved or declined from 2022 to 2023.  

I now want to create another measure to add to a card to show the Number of Questions that improved 5% or more.  Here's what I've tried (among several others), but the answer isn't correct.  It's giving me 88 as the answer.  It should be 2.  

MEASURE1 = countrows(filter('EVS','EVS'[Yrly Delta]>=-.05))

here's a bit of what my data looks like (Yrly Delta is a measure):

[Anonymous]

Hi @Anonymous 

Based on your needs, I have created the following table.

You can use the following dax to get the result you want:

Measure = CALCULATE(COUNTROWS('EVS'),FILTER('EVS','EVS'[Yrly Delta]>=0.05))

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

My table is laid out like this below so that I can have slicers for year & org code.  Do you recommend changing how my table is laid out to accomplish my goal? 

[Anonymous]

Hi @Anonymous 

If it achieves your goals, it's worthwhile to make the appropriate changes to your table layout.

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.