dax expressions

[Anonymous]

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. 

[v-frfei-msft]

Hi @Anonymous,

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

[Anonymous]

I'm not sure how to do that.

You need the PBIX file, its rather big