Forum Discussion

danielboi's avatar
danielboi
Helper I
5 years ago
Solved

Avoiding filtered context with Variable. Help needed

Hello everybody,   making good progress with my Power Bi and now in fine tuning mode. I am building a financial report which is based on a download from our corporate data warehouse. (Very simplifi...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    danielboi , In the above I see one change , if that can work for you

     

    VAR DateMax =
    CALCULATE(
    MAXX(
    filter(allselected(FactFIRE),
    FactFIRE[Version ID]=2)    ,
    FactFIRE[Period ID]
    )
    )
    RETURN

amitchandak's avatar
amitchandak
Super User
5 years ago

danielboi , In the above I see one change , if that can work for you

 

VAR DateMax =
CALCULATE(
MAXX(
filter(allselected(FactFIRE),
FactFIRE[Version ID]=2),
FactFIRE[Period ID]
)
)
RETURN

danielboi's avatar
danielboi
Helper I
5 years ago

Yesssssss!!!!!! You did it.

 

This did the trick.

 

Meanwhile I also found a solution to create a separate table with the needed date, but I like this much better 🙂