topic Applying a segmentation filter to a DAX formula in DAX Commands and Tips

Applying a segmentation filter to a DAX formula

icerdeira — Tue, 21 Dec 2021 11:21:14 GMT

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

Re: Applying a segmentation filter to a DAX formula

amitchandak — Tue, 21 Dec 2021 11:44:30 GMT

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

Re: Applying a segmentation filter to a DAX formula

icerdeira — Tue, 21 Dec 2021 19:05:26 GMT

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

Re: Applying a segmentation filter to a DAX formula

Icey — Fri, 24 Dec 2021 01:58:27 GMT

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.