Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
User | Count |
---|---|
92 | |
87 | |
77 | |
73 | |
68 |
User | Count |
---|---|
116 | |
107 | |
88 | |
65 | |
63 |