Forum Discussion
Oros
Post Prodigy
Post ProdigyAdd filter to a measure
Hello. How do you add filters to a measure? I plan to create 2 measures (with filters) and add them together by creating another measure. For example, I would like to create a measure for SA...
First of all define the base measure
Base Sales Measure := SUM('MyTable'[Sales])Then you can build on top of that measure
Sales For Selected Customers January := CALCULATE([Base Sales Measure], 'MyTable'[Customer Name] in {"A", "B", "C"}, 'DimDate'[MonthName] = "January" )I hope you got the logic
JirkaZ
Solution Specialist
Solution SpecialistFirst of all define the base measure
Base Sales Measure := SUM('MyTable'[Sales])Then you can build on top of that measure
Sales For Selected Customers January := CALCULATE([Base Sales Measure],
'MyTable'[Customer Name] in {"A", "B", "C"},
'DimDate'[MonthName] = "January"
)I hope you got the logic
