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
I have a matrix in my dashboard im building, and i want to add a column that calculates the % per line of the total, there are slicers and selections that will alter this number, suxh as date range etc, i have tried to build a calculated column, but it jsut keeps returning an error, this is simple to do in excel but doing this in Power BI when i dont get an error, all i get is 100% for everythiing, how is this done?
For instance i want to divide 13/165 then 2/165 then 24/165 and so on, i have a card visual that shows me 165 as a total number, but i cant get a measure to work with that without returning 100% where it is picking up the row name, for example Row A, Row B, then it is saying im dividing 13/13 and 2/2 etc.
Anyone have any ideas how this is done?, Thanks
Solved! Go to Solution.
Hi @Schoif-D,
Add the column you want to calculat (No Complaints) then just select quick calc and Show value as % of grand total, it's good for average, sum, ... and can be used in all visuals
Regards
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @Schoif-D,
Add the column you want to calculat (No Complaints) then just select quick calc and Show value as % of grand total, it's good for average, sum, ... and can be used in all visuals
Regards
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering 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 |
---|---|
114 | |
98 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |