Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
User | Count |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |