Earn 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 |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |