POWER BI Measure for dividing total sales by each person by total sales

[alek483]

I have made an measure for showing total sales by each person. I can't figure how to make an measure for dividing total sales by each person BY total sales. For example, for the person "bmo" I want to calculate 303/3153 and so on.

I have tried using the same measure as I use on "Totalt antall salg" and use the Show value as, but that just shows the correct value, and does not calculate it, and I need to use the number for later.

[tamerj1 · Accepted solution]

Hi @alek483 

please try

% Sales =
DIVIDE (

[Totat antall salg],
CALCULATE ( [Totat antall salg], ALL ( Kassejourna[brukernavn] ) )

)

[alek483]

Thank you, worked like a charm!