Forum Discussion
Solved
Measure not filtering as expected
Dear all, I need to calculate the amount of repeated incidents per category and the incidents need to have a standard solution. I used the following formula to calculate it (I have blanked out th...
Thanks for your help! I altered your measure a little bit, and it works!
This is the measure I ended up using:
KPI = CALCULATE(( COUNT(Table[Brief Description (Details)])), FILTER(Table,[Standard solution] = "Yes" ) )
Sharu ,
How about measure below?
KPI =
CALCULATE (
COUNT ( Table[Brief Description (Details)] ),
FILTER (
ALLEXCEPT ( Table, Table[Brief Description (Details)] ),
Table[Standard solution] = "Yes"
)
)
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for your help! I altered your measure a little bit, and it works!
This is the measure I ended up using:
KPI = CALCULATE(( COUNT(Table[Brief Description (Details)])), FILTER(Table,[Standard solution] = "Yes" ) )