Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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
I'm not sure how to do that.
You need the PBIX file, its rather big
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |