Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I am using the below formula and the subtotals are the same as the total for YTD Actl & YTD Bdgt. How can I adjust my formula to display the correct subtotals?
Solved! Go to Solution.
HI @pschn1993,
I'd like to suggest you take a look at the following link to know how to use if statement with Dax functions to check the current row context level and redirect to corresponding context level expressions:
Clever Hierarchy Handling in DAX - SQLBI
In addition, if you are working with multiple aggregation scenarios(they may appear when the measure formula is calculated on the total level), you can also take a look at blow blog about 'measure total level calculation' with multiple aggregations.
Measure Totals, The Final Word
Regards,
Xiaoxin Sheng
HI @pschn1993,
I'd like to suggest you take a look at the following link to know how to use if statement with Dax functions to check the current row context level and redirect to corresponding context level expressions:
Clever Hierarchy Handling in DAX - SQLBI
In addition, if you are working with multiple aggregation scenarios(they may appear when the measure formula is calculated on the total level), you can also take a look at blow blog about 'measure total level calculation' with multiple aggregations.
Measure Totals, The Final Word
Regards,
Xiaoxin Sheng
User | Count |
---|---|
13 | |
5 | |
2 | |
1 | |
1 |
User | Count |
---|---|
24 | |
3 | |
3 | |
2 | |
2 |