Show rows based on selected date

Hi,

It seems the issue you have is the way visualize reportting_date_from. Let's take the following data as an example:

If we use MAX and test if the value is 1 category A will return 0. Similarly to your 11th and 16th dates for !CE2VDML

We can solve this with a filter measure. So le'ts take the filter and apply that with logical test.

First I created a slicer table similarly to your ReportingCal

Filter measure:

Measure 31 = IF(MAX('Table (41)'[Column1])=MAX('Table (40)'[Column1]),1,0)


Now when we apply  this measure as a filter and apply slicer following happens:

 

Here  the originally faulty row of category A now returns 1 as expected.

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/