cancel
Showing results for
Did you mean:  Super User

## Needing help with Countrows Measure

I am needing help with a COUNTROWs measure thats looking at counting rows where that contract falls out of target. Measure as follows:

Count CE % Difference > 90 =
CALCULATE (
COUNTROWS ( KPI_Data ),
FILTER (
KPI_Data,
[CE % Differance] > 90
)
)

'[CE % Differance]' is a seperate measure which is a % difference value which is as follows:
CE % Differance =
SUM(KPI_Data[CE Agreed]) / SUM(KPI_Data[CE taken ])

I'm not getting the expected result when using the COUNTROWs measure, I believe this may be due to the reliance on the second measure in the calculation.

Any help with this would be greatly appreciated.

1 ACCEPTED SOLUTION  Solution Sage

pls try this

``````Count CE % Difference > 90 =
CALCULATE (
COUNTROWS ( KPI_Data ),
FILTER (ALL(
KPI_Data),
[CE % Differance] > 0.9
)
)``````

2 REPLIES 2  Solution Sage

pls try this

``````Count CE % Difference > 90 =
CALCULATE (
COUNTROWS ( KPI_Data ),
FILTER (ALL(
KPI_Data),
[CE % Differance] > 0.9
)
)``````  Super User

Thankyou, sometimes the solution is right in front of you lol  