Showing results for 
Search instead for 
Did you mean: 
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. 











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.




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