Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
87 | |
85 | |
68 | |
66 | |
64 |
User | Count |
---|---|
208 | |
120 | |
113 | |
79 | |
72 |