Dax percentage of column

[Whatever2]

hi everyone 

I'm trying to calculate the percentage for the total of a column but i can't seem to be able to have a single mesure with the total of that column to divide each row with i keep ending up with the total of the row and not of the column 

Mesure = SUM('Prenium n-2 BI'[n-1])

this give me the total if i put it on visual on it's own but i soon as try to put it with the rest of my data it get segregate and it's behaving the same way when i try to divide it by the number in my row  with the following formula 

sum N-1 = DIVIDE(SUMX('Prenium n-2 BI',[n-1]),[Mesure])*100

thanks in advance 

[Yggdrasill · Accepted solution]

Total = SUM(YourNumbers)

%ofTotal = 
    DIVIDE ( [Total] ; CALCULATE ( [TOTAL] ; ALL (YourTable) ) )

Try this

[Whatever2]

thank you so much i've been struggling for like 2 hour on this 

[Yggdrasill]

Most welcome, we've all been there - keep going