Forum Discussion
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...
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.
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.
Amazing, it works perfect, thank you so much!!!