Forum Discussion

yasbos's avatar
yasbos
Resolver II
3 years ago
Solved

Context Filter Help

Hi. I thought I had completely understood how this works, but now I'm doubting myself. You see, I have a calendar table and a service table. They are related 1-to-many on the date. There are certain ...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi yasbos ,

    It seems that you are trying to get the maximum value of the [Date] column in the service table and ignore the filtering context on this column.

    Please try this.

    Current_Date =
CALCULATE ( MAX ( service[date] ), ALL () )

     

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi yasbos ,

It seems that you are trying to get the maximum value of the [Date] column in the service table and ignore the filtering context on this column.

Please try this.

Current_Date =
CALCULATE ( MAX ( service[date] ), ALL () )

 

Best Regards,
Gao
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

yasbos's avatar
yasbos
Resolver II
3 years ago

Thanks, Anonymous