cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Allpat64 Frequent Visitor
Frequent Visitor

dax expressions

Hi All running the following Measure and working fine on detail lines in a grid but in subtotal the numbers are ugly

 

MTD_PY_Variance_Matrix = Calculate(KPI_Finance_Matrix[MTD_Actuals_Matrix]-KPI_Finance_Matrix[MTD_PY_Actuals],KPI_Finance_Matrix[Group]="Revenue") + Calculate(KPI_Finance_Matrix[MTD_Actuals_Matrix]-KPI_Finance_Matrix[MTD_PY_Actuals],KPI_Finance_Matrix[Group]="Gross Margin") +

CALCULATE(KPI_Finance_Matrix[MTD_PY_Actuals]-KPI_Finance_Matrix[MTD_Actuals_Matrix],KPI_Finance_Matrix[Group]="Operating Expenses")

 

If I calculate Revenue separate works fine, but when I concatenate the three calculate statements together it chokes the Subtotal. Seems to be pulling in other values. 

 

 

 

Dax.PNG

 

 

 

 

 

 

2 REPLIES 2
Community Support Team
Community Support Team

Re: dax expressions

Hi @Allpat64,

 

Could you please share your sample data or pbix to me? You can upload your file to onedrive and share the link here.

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Allpat64 Frequent Visitor
Frequent Visitor

Re: dax expressions

I'm not sure how to do that.

 

You need the PBIX file, its rather big