Filter for multiple Criteria's

Question

Hi Experts&nbsp;P01 =VAR CurrentDept = SelectedValue (Template[DeptGrp])ReturnCalculate([Actuals], Filter('Sales',Sales'[Department] =CurrentDept))&nbsp;I want to be able to get the value for each year and period for a given department&nbsp;Dept&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; year&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Value&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;PeriodMarketing&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2020&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;P01Marketing&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2020&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;P02Marketing&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2020&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;P03&nbsp;the above gives me 15.&nbsp;&nbsp;&nbsp;&nbsp;

alb · Accepted Answer

Anonymous&nbsp;
Please explain a bit more. What is this a measure? If so how are you going to use it (in what kind of visual, with what fields in the visual)? Show the tables in your models and their relationships. And the expected result the measure should yield.
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers&nbsp;
&nbsp;

&nbsp;

Forum Discussion

Filter for multiple Criteria's

2 Replies

Related content

DAX FILTER with multiple criteria

Multiple Criteria Filter

Dynamic Filter creation based on multiple criteria

Sequential Order column based on multiple criteria

DAX filter with multiple criteria