Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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.
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
100 | |
54 | |
21 | |
12 | |
11 |