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.
As you see in the below table, the BLMid% has been calculated correctly and the total and each line % is correct. (no filter has been aplied to the table)
As soon as I apply a slicer filter, then the % does not get calculated correctly for the filtered data.
I expcet in the below table 16.88% to be 100% and each row to be % of that line to the filtered total
Solved! Go to Solution.
hi @amirghaderi ,
Please try
BLMID% = table1[BLMIDHOUR]/calculate(sum(table1[BLMIDHOUR]),FILTERS(table1[Month]))
If this does not work, can you share PBIX file?
Thanks!
PS: Please accept the solution if it works!!! 🙂
hi @amirghaderi ,
Please try
BLMID% = table1[BLMIDHOUR]/calculate(sum(table1[BLMIDHOUR]),FILTERS(table1[Month]))
If this does not work, can you share PBIX file?
Thanks!
PS: Please accept the solution if it works!!! 🙂
It works well with date as the row measurement. but, can this be done dynamicly. for example, if I change the row grouping to something else, then does not calculate correctly, example as below:
hi @amirghaderi
Couldn't think of any other way, but in case there are not many grouping, try this
Please try
BLMID% = table1[BLMIDHOUR]/calculate(sum(table1[BLMIDHOUR]),FILTERS(table1[Month]),FILTERS(table1[Status]),FILTERS(table1[column3]))
Thanks!
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 |
---|---|
96 | |
95 | |
80 | |
74 | |
66 |
User | Count |
---|---|
130 | |
106 | |
105 | |
86 | |
72 |