Forum Discussion

dev85's avatar
dev85
Frequent Visitor
3 years ago
Solved

Distinct count grouping measure

Hello guys!   I have the next table   Client name Compliance A YES A YES B NO C YES D YES E YES E YES A NO I need to set up a measure with a distinc count ...
Need Help
  • v-zhangti's avatar
    v-zhangti
    3 years ago

    Hi, dev85 

     

    You can try the following methods.

    Measure =
CALCULATE (
    DISTINCTCOUNT ( 'Table'[Client name] ),
    FILTER (
        ALL ( 'Table' ),
        CALCULATE (
            MIN ( 'Table'[Compliance] ),
            ALLEXCEPT ( 'Table', 'Table'[Client name] )
        ) = "YES"
    )
)

    Is this the result you expect?

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-zhangti's avatar
v-zhangti
Community Support
3 years ago

Hi, dev85 

 

You can try the following methods.

Measure =
CALCULATE (
    DISTINCTCOUNT ( 'Table'[Client name] ),
    FILTER (
        ALL ( 'Table' ),
        CALCULATE (
            MIN ( 'Table'[Compliance] ),
            ALLEXCEPT ( 'Table', 'Table'[Client name] )
        ) = "YES"
    )
)

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

dev85's avatar
dev85
Frequent Visitor
3 years ago

It worked perfectly! I just remove the ALL function because I needed for the measure to be dynamic according to the page filters. 
Thank you so much!