Forum Discussion

Aruljoy's avatar
Aruljoy
Icon for Helper II rankHelper 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.

     

     

TheoC's avatar
TheoC
Icon for Community Champion rankCommunity Champion
4 years ago

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

_2

 

You 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

_2

Also, just below is a screenshot of the output:

Let me know how it goes Aruljoy 

Cheers,

Theo

 

Aruljoy's avatar
Aruljoy
Icon for Helper II rankHelper II
4 years ago

I tried the above DAX query for my logic, still count is not matching

  • TheoC's avatar
    TheoC
    Icon for Community Champion rankCommunity Champion
    4 years ago

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

     

     

    • Aruljoy's avatar
      Aruljoy
      Icon for Helper II rankHelper II
      4 years ago

      Thanks TheoC . This works for me..

      • TheoC's avatar
        TheoC
        Icon for Community Champion rankCommunity Champion
        4 years ago

        Aruljoy no trouble at all! All the best 👍 

  • TheoC's avatar
    TheoC
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Hi Aruljoy please use the measure as it's written.  You need to use > and not the = sign.

     

    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

    _2

      Your output is wrong because of the = sign per below:

    Once this is corrected, the output will be correct.

     

    Thanks,

    Theo