Percentage of total as DAX

[KristyP]

Hi,

I am in need of some assistance. I have tried several different ways of doing this. Basically I need percentage of total that can be used in further DAX. What the data looks like is below.

[KristyP]

Thank you, a minor tweek and I got the result I was after.

[v-zhangti]

Hi, @KristyP 

Based on the data you have provided, what kind of output do you expect? Examples can be given.

Best Regards,

Community Support Team _Charlotte

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

[KristyP]

The measure produced needs to be a percentage, this percentage will then need to be applied to a column in the sales dataset.

The percantage can be of grand total. Or it can be calculated per customer.

[v-zhangti · Accepted solution]

Hi, @KristyP 

You can try the following methods.

Measure%1 = 
Var _N1=CALCULATE(SUM('Usage'[2022 Achievable Revenue]),ALLEXCEPT('Usage','Usage'[Customer]))
Var _N2=CALCULATE(SUM('Usage'[2022 Achievable Revenue]),ALL('Usage'))
Return
DIVIDE(_N1,_N2)

Measure%2 = 
Var _N1=CALCULATE(SUM('Usage'[2022 Achievable Revenue]),ALLEXCEPT('Usage','Usage'[Customer],'Usage'[Product Group]))
Var _N2=CALCULATE(SUM('Usage'[2022 Achievable Revenue]),ALL('Usage'))
Return
DIVIDE(_N1,_N2)

Is there an output that you expect?

Best Regards,

Community Support Team _Charlotte

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