How to group row values for distinct count

Hi Anonymous 

You talk about a chart but mention only one dimension you want to show? Place this measure in a card visual:

Measure =
COUNTROWS (
    FILTER (
        DISTINCT ( Table1[EmailAddress] ),
        CALCULATE ( SUMX ( Table1, Table1[Opened] * 1 ) ) = 0
    )
)

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

Hi Anonymous ,

Based on your description, you can create a measure like this:

Distinct =
IF (
    COUNTX (
        FILTER (
            ALL ( 'Table' ),
            'Table'[Email address]
                IN DISTINCT ( 'Table'[Email address] )
                    && 'Table'[opened] = TRUE ()
        ),
        [Email address]
    ) >= 1,
    0,
    CALCULATE (
        DISTINCTCOUNT ( 'Table'[Email address] ),
        FILTER (
            ALL ( 'Table' ),
            'Table'[Email address] IN DISTINCT ( 'Table'[Email address] )
        )
    )
)

Attached a sample file in the below, hopes to help you.

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.