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...
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.
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.