Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Absolute max in visual

Hi guys,   Im a bit noob still. I need to see the maximum of e.g. the active users while now it filters to the max of the category selected. The use case is:   I have active users e.g. 5000 I h...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    Hi Anonymous 

    Create measures

    min = 0

max = CALCULATE(DISTINCTCOUNT('Table'[user id]),ALL('Table'))

Measure = DISTINCTCOUNT('Table'[user id])

     

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

v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous 

Create measures

min = 0

max = CALCULATE(DISTINCTCOUNT('Table'[user id]),ALL('Table'))

Measure = DISTINCTCOUNT('Table'[user id])

 

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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Your a boss v-juanli-msft. It worked!

Thank you so much.