Forum Discussion
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...
icerdeira , You can use what if parameter
calculate(Avergae(Table[Value]), Filter(all(table), Table[Year] = [what if measure]))
amitchandak
Super User
Super Usericerdeira , You can use what if parameter
calculate(Avergae(Table[Value]), Filter(all(table), Table[Year] = [what if measure]))
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
