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.
Hello everyone,
I am currently struggling with what actually appears quite simple:
As you can see on the screeshots below, I have different amounts distributed per category on a graph, and the corresponding figures written on two columns.
To get a comparision, I unlinked the graph and the "GLOBAL"column so the value is not affected by the selection, while the "SELECTION" column display the filtered value.
However, I would like to get the "SELECTION" value as a percentage of the Global.
Problem is, if I create a measure like :
Solved! Go to Solution.
Hey,
This should work.... normally.
SUM('Table_1'[Quantity orders])/calculate(SUM('Table_1'[Quantity orders]);all(Table_1'[Global]))
Let me know how it turned out / mark it as solved if it works for you.
Hey,
This should work.... normally.
SUM('Table_1'[Quantity orders])/calculate(SUM('Table_1'[Quantity orders]);all(Table_1'[Global]))
Let me know how it turned out / mark it as solved if it works for you.
It does work !
Thanks a lot
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 |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |