Applying a segmentation filter to a DAX formula

[icerdeira]

I need help to pass by parameter a Year value for a column or measure in DAX. So far I have only been able to indicate the minimum value of the year (2015), but what I need is not to have to indicate it manually but to change it with the segmentation filter. I need the average price for 2015 and the average price for 2020. I would like it to change as I change the value in the segmentation filter and not have to change it manually in the formula.

Thanks,

Isaac

[amitchandak · Accepted solution]

@icerdeira , You can use what if parameter

calculate(Avergae(Table[Value]), Filter(all(table), Table[Year] = [what if measure]))

https://docs.microsoft.com/en-us/power-bi/desktop-what-if

[icerdeira]

Hello @amitchandak ,

Thanks for your answer. I'm trying to do it and it says: Need one more argument in my function.

I created a what if, with the years from 2006 to 2025 and make the relation and it works ok.

There is something wrong on my formula.

Thanks!

Isaac

[Icey]

Hi @icerdeira ,

Closing parenthesis is missing after ALL('Mercado' and there is an extra closing parenthesis at the end of the expression.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.