Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
87 | |
87 | |
68 | |
66 | |
63 |
User | Count |
---|---|
208 | |
120 | |
113 | |
79 | |
72 |