Forum Discussion
Create DAX subtotal measure based on 2 columns
I have 2 columns
[Franchise] and [Metier] in table 'Product mapping
I also created a combined column which i do not want in my visual.
When i add the combined column to the visual It shows the correct value.
When i remove it it doesn't.
SO i am trying to write a measure that calculates a subtotal based on the 2 individual columns.
I have a measure [2022 units] in table '2021/2022 Aug YTD Product P&L to sum up.
CALCULATE(
sum('2021/2022 Aug YTD Product P&L'[2022 Units])
,REMOVEFILTERS('2021/2022 Aug YTD Product P&L')
,FILTERS('Product Mapping'[Filter F-M])) --- this is the combined field
Hi Anonymous ,
Please have a try.
test = VAR currentitem = SELECTEDVALUE ( 'Product Mapping'[Filter F-M] ) RETURN CALCULATE ( SUM ( '2021/2022 Aug YTD Product P&L'[2022 Units] ), FILTER ( ALL ( '2021/2022 Aug YTD Product P&L' ), 'Product Mapping'[Filter F-M] = currentitem ) )How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi Anonymous ,
Please have a try.
test = VAR currentitem = SELECTEDVALUE ( 'Product Mapping'[Filter F-M] ) RETURN CALCULATE ( SUM ( '2021/2022 Aug YTD Product P&L'[2022 Units] ), FILTER ( ALL ( '2021/2022 Aug YTD Product P&L' ), 'Product Mapping'[Filter F-M] = currentitem ) )How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.