Forum Discussion

JordanJackson's avatar
JordanJackson
Advocate II
3 years ago
Solved

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 ...
Need Help
  • Ahmedx's avatar
    Ahmedx
    3 years ago

    pls try this

     

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

     

Ahmedx's avatar
Ahmedx
Super User
3 years ago

pls try this

 

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

 

  • JordanJackson's avatar
    JordanJackson
    Advocate II
    3 years ago

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