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.
Is there any way in the below example to set Power Bi to calculate each row % from total highlighted in yellow (Total of baseline) and (Total of Current) and not the full line total.
It means that there will be 100% for current and 100% for Baseline
Hi @amirghaderi,
I think you can add if statement to check the current content level and write specific DAX expression for the subtotal level calculations:
Clever Hierarchy Handling in DAX - SQLBI
If you are confused about the coding formula, please share some dummy data to test.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
Please share sample pbix
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 |
---|---|
115 | |
99 | |
88 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |