Calculating percentage of difference from total dataset average to a particular row

[knamburi]

Hello All,

Looking for suggestion to solve a problem

triptime (column C ) is a measure column 

now i want to find the total average - of trip time which is 322.84 in this case and want to calculate how each driver is doing against average.

I tried using CALCULATE(AVERAGE(measure))  and few other methods but did not work

below is the example to calculate Average %

any help is appreciated. 

Regards,

K

[knamburi]

Thank you so much - this really solved my problem. Missing REMOVEFILTERS() - i never thought about it

But i have another question, this will disable all the filters - how can i exclude few specific - like i want to use few - i tried using KEEPFILTERS() but i guess its not working as expected.

[Ahmedx]

to exclude something specific you need to use ALLEXCEPT functions
or additionally write VALUES:

m1 = CALCULATE(
[total average],REMOVEFILTERS(),VALUES('table'[Category]),
VALUES('table'[Year]))

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.

[Ahmedx · Accepted solution]

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.