Forum Discussion

kshre's avatar
kshre
Frequent Visitor
7 years ago
Solved

Distinct Count Filter with Metrics

Hello, I need help with a Metrics that will do a Distinct Count of a user column with a filter of Count of User > 1. The table below is and example the regular distinct count. Both distinct count a...
Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi kshre 

    You may create a measure like below:

    Count = 
VAR a =
    SUMMARIZE (
        Table3,
        Table3[Year],
        Table3[Month],
        Table3[User],
        "b", COUNTA ( Table3[User] )
    )
RETURN
    COUNTROWS ( FILTER ( a, [b] > 1 ) )

    Regards,

v-cherch-msft's avatar
v-cherch-msft
Microsoft Employee
7 years ago

Hi kshre 

You may create a measure like below:

Count = 
VAR a =
    SUMMARIZE (
        Table3,
        Table3[Year],
        Table3[Month],
        Table3[User],
        "b", COUNTA ( Table3[User] )
    )
RETURN
    COUNTROWS ( FILTER ( a, [b] > 1 ) )

Regards,

kshre's avatar
kshre
Frequent Visitor
7 years ago

Hi v-cherch-msft,

 

Thank you for your help, that measure does exactly what I need.