relational table
1 Topic
Filter Using a Slicer With No Relational Table
Good day, I am trying to filter my data like you would do in SSRS by using a paramter. I want to see Site Visits to Clients base on a Slicer Value. I have the Main Table with client, and a calculated column to calculate the site visits based on the Arrival time. Then I created a new table with a calculated value for the numbers " CountFilter = GENERATESERIES(1, 20, 1)" Now I cant get it to filter I have tried to create a relationship between the two by and it went for Many-to-One (MainTable - to - CountFilter) When I leave it on single then I only get a 1 or 0 value, if I leave it on Both direction then i get all the values from 1 to 20 but it shows no data when I select anything other than 1 Visual is a simple table with customer and the Sum of Site visits the DAX calculate column code is SiteVisits = IF(NOT(ISBLANK('MainTable'[ArrivalTime].[Date])), 1, 0) Does anyone have an Idea where I can start to troubleshoot. Or if there is any alternitave? Main Goal is select 5 for instance and then i see all customers with 5 site vistis or more. Greater than 5 PS. I tried this below as well, did not work. Filtered Visits = VAR SelectedCount = SELECTEDVALUE(CountFilter[Value]) RETURN CALCULATE( COUNTROWS(FILTER('MainTable', NOT(ISBLANK('MainTable'[ArrivalTime].[Date])))), FILTER(CountFilter, CountFilter[Value] <= SelectedCount) )Solved1.2KViews0likes3Comments