Forum Discussion
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:
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/
hi ValtteriN can please explain with dates , i tried using dates but the measure (measure 30 ) you suggested comapres it with value 1.
current measures and single date slicer table
Hi,
So with dates the measure 30 would be the [show_hide_report_view]. Measure 31 would be the like you have in your example, but keep in mind that there shouldn't be relationships between slicer and fact table. Additionally you need to apply the filter measure to your visual. So Measure 31 = 1 needs to be applied. The idea here is that if your test measure [show_hide_report_view] checks for date matches by applying the filter measure logic your table will only show rows with reporting_date = "slicer selection". In my Example by selecting 1 the row with Category = A & Column1 = 2 was filtered out. Because of this the test measure returns 1. In your case this would mean that the table shows only 11.1.2024 and thus the test measure is 1.