Forum Discussion

Aruljoy's avatar
Aruljoy
Helper II
4 years ago
Solved

Count 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]=...
Need Help
  • TheoC's avatar
    TheoC
    4 years ago

    Aruljoy you used the wrong measure.  You have = 0 instead of > 0. Please fix your measure and try again.

     

     

sevenhills's avatar
sevenhills
Super User
4 years ago
Fail Only Flag = 
var _a = COUNTROWS( Filter( 'Table', if ( 'Table'[Measure_SuccesCount] = 0 && 'Table'[Measure_FailCount] > 0, 1, 0)))
RETURN If (ISBLANK(_a), 0, _a)

 

Try this

Aruljoy's avatar
Aruljoy
Helper II
4 years ago

 

 

Measure_Successsount & Measure_failcount are also measures.  Eg, The first row should return as 0, but I am getting 36.

Measure_Successcount =
Var Result = CALCULATE(countrows(TransactionData),FILTER(TransactionData,TransactionData[TransactionTypeDerived]="success"))
Return if(isblank(Result)=TRUE(),0,result)

 

 

Measure_Failcount =
--Var StarDate = MIN(DimDate[TransactionDate])
--Var EndDate = max(DimDate[TransactionDate])
Var Result = CALCULATE(countrows(TransactionData),FILTER(TransactionData,TransactionData[TransactionTypeDerived]="fail"))
Return if(isblank(Result)=TRUE(),0,result)
  • sevenhills's avatar
    sevenhills
    Super User
    4 years ago

    In your original post, you said as "....measure basen columns"

     

    DAX behave differently for measures vs columns.

     

    Try this:

     

    Fail Only Flag 2 = 
var _a = if ([Measure_FailCount] > 0 && [Measure_SuccesCount] = 0, 1, 0)  
var _t1 = SUMMARIZE('Table','Table'[MemID], "__Value1",  if ([Measure_FailCount] > 0 && [Measure_SuccesCount] = 0, 1, 0) )

RETURN If( HASONEVALUE('Table'[MemID]), _a, Sumx(_t1, [__Value1]))