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

danielboi's avatar
danielboi
Helper I
5 years ago

1 more remark. If I create a measure extracting the max date and put it into a matrix visual it looks like this:

If I change the filtered version to FC it looks like this: 

 

The Dax:

MaxDate =
   VAR VersionID2only =
      FILTER(
         FactFIRE,
         FactFIRE[Version ID]=3
      )
   RETURN
maxx(
   VersionID2only,
   FactFIRE[Period ID]
)