Crossfiltering based on measure

[Maria9292]

Hi!

I need to create a tab with a chart with number of employees over time and other vizualizations so they all that could cross-filter each other.

 I managed to do the chart, the DAX is:

With 2 inactive relationships between 2 tables: (Date ->Start Date and Date -> End Date)

And I can't figure out how to make this chart filter other vizualiations based on Append_Staff_data.

I get why it doesn't filter, I can't figure out how to create dependencies so the vizes could filter each other.

Any advice?

Maria

[Maria9292 · Accepted solution]

I have found a mistake I made - I used ALL that removed all the filters. 

[Maria9292]

Basically, I need to be able to see details of each date I choose: how namy employees are there, what departments they are from, their names etc. 

If this can be achieved using different logic, I am open to any suggestions)

[AlB]

@Maria9292 

can you share the pbix?

Please accept the solution when done and consider giving a thumbs up if posts are helpful.  Contact me privately for support with any larger-scale BI needs, tutoring, etc.

[Maria9292]

@AlB sure, here it is. Thanks!