Forum Discussion

Sasha's avatar
Sasha
Helper III
6 years ago

Key influencers analyzing measure

Hi, I'm trying to implement the new feature of analyzing measure in the key influencers visualization. Suppose I have a table of sales with columns Region, Month, Units Sold, Total Revenue. I woul...
Need Help
v-xuding-msft's avatar
v-xuding-msft
Community Support
6 years ago

Hi Sasha ,
Please try the following formula.

Revenue/Unit = 
var a = CALCULATE(SUM(Sales[Total Revenue]),ALL(Sales))
var b = CALCULATE(SUM(Sales[Units Sold]),ALL(Sales))
return
DIVIDE(a,b)

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Sasha's avatar
Sasha
Helper III
6 years ago

v-xuding-msft 

Thank you!

However, this will result in a constant number of Revenue/Unit - meaning for every filter it will return the grand average - so there won't be any difference between a particulr group average and the total average.

By the way - in the file you uploaded - if I remove Months (or other columns) from "explain by" and then return it back the results change - it seems like the visualization is not stable.