Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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. 

 

 

 

 

 

 

 

 

 

2 Replies

  • v-frfei-msft's avatar
    v-frfei-msft
    Icon for Community Support rankCommunity Support

    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's avatar
      Anonymous
      Not applicable

      I'm not sure how to do that.

       

      You need the PBIX file, its rather big