Need help in Total calculation in Power BI

[Anonymous]

Hi All,

I need help with Power BI Calculation.

Is there a way to by pass Total in a measure in Power BI.

This this below table Channel Mix is a measure and because of the underlying calculation, total is showing as zero, is there a way in Power BI to add total as Row 1 + Row 2 + Row 3 for the below table.

After doing the calculation, I should be getting the sum of 273.62  -333.87+1278.62 instaead of Zero, please help.

Thank you.

[Anonymous]

Hi @Anonymous,

Please take a look at the following blog about measure total level solutions if helps:

Measure Totals, The Final Word 

Regards,

Xiaoxin Sheng

[amitchandak]

@Anonymous , Create a new measure like

channel Mix new = sumx(summarize(Table, Table[Channel], Table[Customer], "_1", [channel Mix]),[_1])

[Anonymous]

HI @amitchandak 

Could you help me to write a measures to add total for Channel Mix, Customer Mix, Brand Mix, Brand Variant Mix, Pack Type Mix, Pack Type 2 Mix, Pack Size.

The values have to be changed based up on the slicers selected on top of the visual.

Thank you.