Forum Discussion

Zahur's avatar
Zahur
Regular Visitor
1 year ago
Solved

Filter Table Visual by EndDate (Inactive Relationship)

Hi all, I have a very simple model and I’m stuck on something that feels like it should be straightforward. Staff table with columns: Person StartDate EndDate Date table with: Active...
  • Rupak_bi's avatar
    Rupak_bi
    11 months ago

    Hi Zahur ,

    hope this meets your expectation

    Attaching PBIX as well. If works, accept as solution.

  • Zahur's avatar
    Zahur
    11 months ago

    Many thanks Rupak_bi I will accept this as a solution. It creates a measure for use in the table making use of the inactive relationship. It is a shame there was no way to create a measure that worked as a filter but your solution is good!

FBergamaschi's avatar
FBergamaschi
Super User
1 year ago

Hi Zahur 

am I understadning correctly that you are using a measure as a filter for the visual? If yes, you need to consider that this creates the evaluation of the measure with a set of filters identified by the columns you grouped.

 

So to help you I need the pbix, can you share it via private message or put the file in a cloud service and share the link here?

 

I need to understand how the visual is arranged, your DAX is OK but measures used as filters are complex to manage

 

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI

Zahur's avatar
Zahur
Regular Visitor
1 year ago

Thank you for the quick response Francesco. Yes, I am trying to use the Leaver measure as a filter on the table visual. Here is a link to the pbix Example.pbix.