% Difference from Total Average

[lucie_raboch]

Hi experts,

I need your help.

I would like to create a table below, metric = views, average views, total average views and difference from average.

This is my pbi file:

https://drive.google.com/file/d/15sJq2aL0X-t3745OiMW5ZfG1vzz_GGoT/view?usp=drive_link

I have tried so many measures, but It wasnt dynamic, in my original dashboard I have lots of slicers, I need to work together.

Thank you for your help

[lbendlin · Accepted solution]

Views = sum('metrics_bq'[Views])

Views_AVG = AVERAGEX(videos,[Views])

Total Average = CALCULATE(AVERAGEX(videos,[Views]),REMOVEFILTERS(videos[Episodes]))

Difference = [Views_AVG]-[Total Average]

Note: I cleaned up your data model a bit.

[lucie_raboch]

Amazing, it works perfect, thank you so much!!!