Forum Discussion
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...
Hi Sasha ,
How about adding CALCULATE per sum values? Did you try this? Did it work?
Revenue/Unit = DIVIDE(CALCULATE(SUM(Sales[Total Revenue])),CALCULATE(SUM(Sales[Units Sold])))
Due to the sample data is a part of your data, I'm not sure the result I tested is what you want. You could try this firstly. If there is anything wrong, please point it.
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.
v-xuding-msft Hi,
it didn't change anything :(