Forum Discussion

pgardella's avatar
pgardella
New Member
9 years ago
Solved

Average users per group

Good morning!  I am just starting to use PowerBI and DAX, and have been frustrated by what seems like it should be an easy thing.   Given a table like this:   Group_Name Group_ID User_ID ...
Need Help
  • Sean's avatar
    Sean
    9 years ago

    pgardella This should work! :smileyhappy:

     

    User Per Group =
DIVIDE (
    CALCULATE ( COUNTROWS ( 'Table' ), ALLEXCEPT ( 'Table', 'Table'[Group_ID] ) ),
    DISTINCTCOUNT ( 'Table'[Group_Name] ),
    0
)

Sean's avatar
Sean
Community Champion
9 years ago

pgardella This should work! :smileyhappy:

 

User Per Group =
DIVIDE (
    CALCULATE ( COUNTROWS ( 'Table' ), ALLEXCEPT ( 'Table', 'Table'[Group_ID] ) ),
    DISTINCTCOUNT ( 'Table'[Group_Name] ),
    0
)

pgardella's avatar
pgardella
New Member
9 years ago

Well, that is one way I hadn't even considered!  Thank you!