Dax syntaxe help

[Whatever2]

Hi

I have to calculate the % per row of the total , and i first manage to do it with this formula :

%total 2016 = SUM('prenium n-2 ratio'[2016])/CALCULATE(SUM('prenium n-2 ratio'[2016]),ALL('prenium n-2 ratio'[broker_name]))*100

wich worked fine and had correct number , then i had to change the column name for some reason so i had the next formula as a result :

 %total n-2 = SUM('prenium n-2 ratio'[n-2])/CALCULATE(SUM('prenium n-2 ratio'[n-2]),ALL('prenium n-2 ratio'[broker_name]))*100

and now the figures are wrong (100 for every row ) and i can't understand why (the colulmn name in the function does match with my table ) , I would like to understand why .

in red :calculated with dax , in green : same formula but on excel

as you can see the totals are the same but the figures are not

The main question here is why do i get different result with the same formula ?

Thanks .

[Greg_Deckler]

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490