Forum Discussion

lucie_raboch's avatar
lucie_raboch
Icon for Helper II rankHelper II
1 year ago
Solved

% Difference from Total Average

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

"DAX "
Desktop
  • lbendlin's avatar
    lbendlin
    1 year ago
    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.

     

     

     

2 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    1 year ago
    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.