distinct count if

[dgdgdg122db]

Hi,

I wan to see the distinct count of emails which have a total login >= 16 times 

Can someone please help 😞

[v-lid-msft · Accepted solution]

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,

[MFelix]

Hi @dgdgdg122db ,

Try the following measure:

Count Emails =
COUNTROWS (
    FILTER (
        SUMMARIZE (
            ALLSELECTED ( 'Table'[email]; 'Table'[Month] );
            'Table'[email];
            "@LoginCount"; SUM ( 'Table'[Logins] )
        );
        [@LoginCount] >= 16
    )
)

I have used the allselected so if you want to add a slicer by e-mail or month it will return the calcution.