Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Tricky count measure

I have a tricky measure that I don't know how to proceed on.  I have a table with key1 (table A) that is always unique to a person. But this person can have multiple of value2 that can be found in t...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    HI Anonymous,

    You can create a measure formula to count values in value3 field based on key1 group:

    formula =
CALCULATE (
    COUNTROWS ( VALUES ( Table[Value3] ) ),
    ALLSELECTED ( Table ),
    VALUES ( Table[Key1] )
)

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
3 years ago

HI Anonymous,

You can create a measure formula to count values in value3 field based on key1 group:

formula =
CALCULATE (
    COUNTROWS ( VALUES ( Table[Value3] ) ),
    ALLSELECTED ( Table ),
    VALUES ( Table[Key1] )
)

Regards,

Xiaoxin Sheng