Forum Discussion

Sasha's avatar
Sasha
Icon for Helper III rankHelper 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
Icon for Community Support rankCommunity 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
    Icon for Helper III rankHelper 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.