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.
Hi guys, can anyone tell me how I can calculate the percentage of total rows.
I calculated the percentage on the total of the columns, but I can't calculate the percentage on the rows, what formula should I use? Mainly I can't get the denominator, then the row total without the context of the columns. Thanks to anyone who can help me
Solved! Go to Solution.
Understood thanks. I think you just need to keep the filter on the color and remove the filter on the company. Same formula as you wrote above but instead of ALL (product color) u should write ALL (dim company table).
If you need further help upload the file or the screenshot of the model view atleast. Otherwise please mark as problem solved.
By the way, you can also utilize the new visual calculations which, as I've seen (though I haven't tried them yet), should make this process very straightforward
I'll try, thanks for the advice!
Can't understand what's your issue, try to explain better
You're right, forgive me!
I want to insert two columns into the matrices that contain the value in the form of a percentage of the total of the columns (e.g. 57,419.41/332,959.20) and in the form of a total on the rows (e.g. 57,419.41/123,988.31). I can't calculate the value of the percentage of the total rows, exactly I can't calculate the denominator that gives me the total rows value of 123,988.31.
Understood thanks. I think you just need to keep the filter on the color and remove the filter on the company. Same formula as you wrote above but instead of ALL (product color) u should write ALL (dim company table).
If you need further help upload the file or the screenshot of the model view atleast. Otherwise please mark as problem solved.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
88 | |
82 | |
65 | |
64 | |
58 |
User | Count |
---|---|
171 | |
113 | |
110 | |
73 | |
73 |