Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Subtracting two measures not working

Hi Community,   I am having an issue with what should be a simple thing to do, calculating the difference between measures. Below is the table:     The "Account" field in rows is a calcula...
calculation groups
DAX
Subtract
ValtteriN's avatar
ValtteriN
Icon for Community Champion rankCommunity Champion
4 years ago

Hi,

I think the issue here is the calculation group precedence logic. Because of this this the calculations do work for whole numbers, but when it comes to decimals the order of operations causes issues. E.g. the percentage difference of MTD calculations is the higlighted one instead of the desired output. Basically I suspect you should change your calculation group precedence. It is a different story if you first calculate ebit and then aggregate it instead of first aggregating the data and then calculating ebit. 

Here is an article by SQLBI discussing the topic: 
https://www.sqlbi.com/articles/understanding-calculation-group-precedence/


I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi ValtteriN 

 

Thank you for the response. Is there a standard order of precedence for calculation groups? For example, if I had several calculation groups:

 

Base measures - Precedence: 10

Ratios - Precedence: 9

Time Intelligence - Precedence: 8

Variances - Precedence: 7

etc, etc, etc

 

I have not been able to find any information on the standard order of operations when it comes to calculation groups. Do you know if there is any such principle/rule to follow?