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.
Newbie here,
Wanted to create a new column and get the desired results highlighted in yellow.
I have 3 columns named apple, orange and mango and need to get total of each column plus percentage in new column. Few column values might be blank or null.
Don't know how to do cause I tried SUMX but its giving me very different result like 184 which I don't know where it comes from.
Any help is greatly appreciated.
Solved! Go to Solution.
Hi, @axarhaan
You can try the following methods.
Total = [Apple]+[Orange]+[Mango]
% = [Total]/3
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @axarhaan
You can try the following methods.
Total = [Apple]+[Orange]+[Mango]
% = [Total]/3
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Commenting on this to bring it to top as I am still struggling to get this work.
Please advise. Thanks.
@axarhaan Multi-Column Aggregations (MC Aggregations) - Microsoft Power BI Community
Thank you for your response and sharing MC Aggregations.
I tried the MC Sum measure per your pbix file and still getting the wrong calculation. What am I doing wrong here?
Please advise. Thanks.
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 |
---|---|
110 | |
101 | |
76 | |
64 | |
63 |
User | Count |
---|---|
141 | |
104 | |
101 | |
80 | |
67 |