Absolute max in visual

[Anonymous]

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 have actions / features the users use e.g. digital signatures, workflow, reporting

What i would like to see is that when i select one of the categories e.g. digital signatures, that it will show 2000 users (out of a total of 5000) in a gauge visual for example. Now it always shows the total of the category, 2000 out of 2000.

I have used the following measurement for the users:

active users = DISTINCTCOUNT(Sheet0[loginname])

(Sheet0[action]) =the column i use for the actions.

Does anyone know what the formula should be to show the absolute max or ignore filtering?

[v-juanli-msft · Accepted solution]

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]

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

Thank you so much.

[AilleryO]

Hi,

Maybe you should look after the ALL() function ?

like in this discussion :

https://community.powerbi.com/t5/Desktop/ALL-function/td-p/194108

A very similar case.

Enjoy