Forum Discussion

Frequent Visitor

4 years ago

Solved

Applying a segmentation filter to a DAX formula

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

amitchandak
4 years ago
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

Frequent Visitor

4 years ago

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

Icon for Community Support rank

Community Support

4 years ago

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.