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.
My husband fixed it using below reference:
https://powerpivotpro.com/2012/03/subtotals-and-grand-totals-that-add-up-correctly/
So he added another measure below
=IF(COUNTROWS(VALUES('Tariffed Receipts Reporting 4'[FiscalMonthYearName]))=1,
[10%],
SUMX(VALUES('Tariffed Receipts Reporting 4'[FiscalMonthYearName]), [10%])
)
Now the grand total is correct
My husband fixed it using below reference:
https://powerpivotpro.com/2012/03/subtotals-and-grand-totals-that-add-up-correctly/
So he added another measure below
=IF(COUNTROWS(VALUES('Tariffed Receipts Reporting 4'[FiscalMonthYearName]))=1,
[10%],
SUMX(VALUES('Tariffed Receipts Reporting 4'[FiscalMonthYearName]), [10%])
)
Now the grand total is correct
Hello @Anonymous
In the context of the total row [Current 10%] is not blank so your SUMX never gets [Sum of 301 Tariff value]. You need to move the IF inside the SUMX like so.
10% = SUMX ( VALUES ( YourTable[FiscalMonthYearName] ), IF ( [Current 10%] = BLANK (), [Sum of 301 Tariff value], [Current 10%] ) )
This will move the check on [Current 10%] into the iteration over VALUES ( YourTable[FiscalMonthYearName] ).
You can try it with the old VALUES list just moving the if, not sure if that will give you what you want though.
10% = SUMX ( VALUES ( 'Tariffed Receipts Reporting 4'[List] ), IF ( [Current 10%] = BLANK (), [Sum of 301 Tariff value], [Current 10%] ) )
Glad you were able to find a solution.
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |