Percentage of total not calculated correctly when filter applies

[amirghaderi]

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

[Anonymous · Accepted 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!!! 🙂

[amirghaderi]

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:

[Anonymous]

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!