Hi, I need to show a list of the counties that were not active in a quarter. I have a full county dimension set (as it's not in my CRM), then I have my data table. I already have a measure that gives me the exact number of active local authorities per quarter. I just need to link the dimension set and show the counties NOT active per quarter. Ho can this be done please? All Counties TableCounties_AllBedfordshireBerkshireBristolBuckinghamshireCambridgeshireCheshireThis is my data set (Bristol is still active as it has 1 property active): CountiesPropertyCreated_date Decommissioned_DateBedfordshireL101/04/202405/10/2024BedfordshireL201/04/202405/10/2024Bristol L301/04/2024 Bristol L401/04/202401/05/2024BuckinghamshireL501/04/202401/09/2024BuckinghamshireL601/04/202401/09/2024BuckinghamshireL701/04/202401/09/2024CambridgeshireL801/04/202401/08/2024CambridgeshireL901/04/202401/08/2024CheshireL1001/04/2024 For example, I need the counties not active to show:BedfordshireBerkshireBuckinghamshireCambridge

RichOB - Make a relationship between your All counties table, and your data table, then use the measure you have that counts the active counties on a table visual (with the column from the dimension), and set the meausre to "is blank" If I answered your question please mark my post as the solution, it helps others with the same challenge find the answer!

Need help joining a table to filter values as not active

Forum Discussion

Related content

conditional join

Spatial Join

Join the community

Joining to a filtered table

Filter a column with duplicate values based on the highest Index value