Forum Discussion
Aruljoy
Helper II
Helper IICount members based on Measure result
Hi, I want to count the no of members who has FailOnlyFlag=1. FailonlyFlag is a measure basen columns measure_Successcount & Measure_failcount FailOnlyFlag = if([Measure_Successcount]=...
AruljoyHelper II
Helper IIits a measure
- TheoC
Community Champion
Aruljoy try this:
Measure =
VAR _1 = COUNTROWS ( FILTER ( VALUES ( 'Table'[MemID] ) , [Measure_SuccessCount] > 0 ) )
VAR _2 = IF ( _1 > 0 , COUNTROWS ( FILTER ( VALUES ( 'Table'[MemID] ) , [Measure_SuccessCount] > 0 ) ) , 0 )
RETURN
_2You can also use ISBLANK to replace the VAR _2 but it's much of a muchness.
Measure =
VAR _1 = COUNTROWS ( FILTER ( VALUES ( 'Table'[MemID] ) , [Measure_SuccessCount] > 0 ) )
VAR _2 = IF ( ISBLANK ( _1 ) , 0 , _1 )
RETURN
_2Also, just below is a screenshot of the output:
Let me know how it goes Aruljoy
Cheers,
Theo