Forum Discussion
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
Community 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
- AnonymousNot applicable
I'm not sure how to do that.
You need the PBIX file, its rather big