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.
I'm missing the Grand Total after using a Multiplication caclulation. Any help would be greatly appreciated.
Formula with issue
Allocated Expense = [Trade Expense] * [Split]
Trade Expense
Trade Expense = CALCULATE(SUM('Trade'[Expenses]),'Trade'[Transaction Type]="Trade Expense")
Split (Percent of Parent Total)
Split =
IF (
ISFILTERED ( PRODUCT_MASTER[Full Part Description] ),
[PercentOfFullPart],
IF (
ISFILTERED ( PRODUCT_MASTER[Product Class] ),
[PercentOfProductClass],
IF (
ISFILTERED ( PRODUCT_MASTER[Product Groups] ),
[PercentOfProductGroup] / [PercentOfProductGroup],
IF ( ISFILTERED ( Customer_Master[Customer] ), 1 )
)
)
)
Solved! Go to Solution.
Not sure what you mean by "missing". Is the grand total wrong? Could be a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
Hi @Tuan ,
Do you mean the result is totally incorrect or the visual cannot show your expected result?
You could share your sample data and expected result to me if you don't have any Confidential Information. Please upload your files to OneDrive for Business and share the link here.
Not sure what you mean by "missing". Is the grand total wrong? Could be a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |