Forum Discussion
Show rows based on selected date
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
Community ChampionHi,
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.