Error in sum of multiple columns

[axarhaan]

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.

[v-zhangti · Accepted 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.

[axarhaan]

@v-zhangti 

Thank you so much. Yes, this worked. 

[axarhaan]

Commenting on this to bring it to top as I am still struggling to get this work.

Please advise. Thanks.

[Greg_Deckler]

@axarhaan Multi-Column Aggregations (MC Aggregations) - Microsoft Power BI Community

[axarhaan]

@Greg_Deckler 

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.