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.
I have the following matrix and table, the subotal is missing in the running totals where the category is empty.
Category | Sub Category | Sub Category 2 | Amount | Date |
1 | 1.1 | 1.1.1 | 1 | 01/01/20 |
1 | 1.2 | 1.2.1 | 1 | 01/02/20 |
1 | 1.3 | 1.3.1 | 1 | 01/03/20 |
1 | 1.1 | 1.1.2 | 1 | 01/04/20 |
1 | 1.2 | 1.2.2 | 1 | 01/05/20 |
1 | 1.3 | 1.3.2 | 1 | 01/06/20 |
2 | 2.1 | 2.1.1 | 1 | 01/06/20 |
2 | 2.1 | 2.1.2 | 1 | 01/05/20 |
2 | 2.2 | 2.2.2 | 1 | 01/04/20 |
2 | 2.2 | 2.2.1 | 1 | 01/03/20 |
2 | 2.3 | 2.3.1 | 1 | 01/02/20 |
I used quick measure for running total -
I added some February rows for only Cat 1 to your sample data to reproduce your issue. Your measure worked fine for me when I did. Is this the needed behavior?
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
@mahoneypat The grand total is there, but the subtotal is still missing even in your table.
Please try this expression. It references your existing measure but should replace it in the visual.
NewMeasure = SUMX(VALUES('Sheet1'[Category]), [Amount running total in category])
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
@mahoneypat sorry it did not work
it does not fill the blank sub total and has also replaced running total with category total
User | Count |
---|---|
86 | |
83 | |
67 | |
61 | |
57 |
User | Count |
---|---|
138 | |
112 | |
94 | |
84 | |
70 |