Forum Discussion

dgdgdg122db's avatar
dgdgdg122db
Helper II
6 years ago
Solved

distinct count if

  Hi, I wan to see the distinct count of emails which have a total login >= 16 times  Can someone please help 😞
Need Help
Show and Tell
Tips and Tricks
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    Hi dgdgdg122db ,

     

    We can also use the following measure to meet your requirement:

     

    Measure = 
CALCULATE (
    DISTINCTCOUNT ( 'Table'[Email] ),
    FILTER (
        ALLSELECTED ( 'Table' ),
        CALCULATE (
            SUM ( 'Table'[logins] ),
            FILTER ( ALLSELECTED ( 'Table' ), 'Table'[Email] = EARLIER ( 'Table'[Email] ) )
        ) >= 16
    )
)

     


    Best regards,

     

v-lid-msft's avatar
v-lid-msft
Community Support
6 years ago

Hi dgdgdg122db ,

 

We can also use the following measure to meet your requirement:

 

Measure = 
CALCULATE (
    DISTINCTCOUNT ( 'Table'[Email] ),
    FILTER (
        ALLSELECTED ( 'Table' ),
        CALCULATE (
            SUM ( 'Table'[logins] ),
            FILTER ( ALLSELECTED ( 'Table' ), 'Table'[Email] = EARLIER ( 'Table'[Email] ) )
        ) >= 16
    )
)

 


Best regards,