Forum Discussion

Whatever2's avatar
Whatever2
Icon for Helper I rankHelper I
8 years ago

Dax syntaxe help

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 .