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 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.
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
@Anonymous , Create a new measure like
channel Mix new = sumx(summarize(Table, Table[Channel], Table[Customer], "_1", [channel Mix]),[_1])
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.
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 | |
97 | |
78 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |