Need help joining a table to filter values as not active

[RichOB]

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 Table

Counties_All

Bedfordshire

Berkshire

Bristol

Buckinghamshire

Cambridgeshire

Cheshire

This is my data set (Bristol is still active as it has 1 property active): 

Counties	Property	Created_date	Decommissioned_Date
Bedfordshire	L1	01/04/2024	05/10/2024
Bedfordshire	L2	01/04/2024	05/10/2024
Bristol	L3	01/04/2024
Bristol	L4	01/04/2024	01/05/2024
Buckinghamshire	L5	01/04/2024	01/09/2024
Buckinghamshire	L6	01/04/2024	01/09/2024
Buckinghamshire	L7	01/04/2024	01/09/2024
Cambridgeshire	L8	01/04/2024	01/08/2024
Cambridgeshire	L9	01/04/2024	01/08/2024
Cheshire	L10	01/04/2024

For example, I need the counties not active to show:

Bedfordshire

Berkshire

Buckinghamshire

Cambridge

[mark_endicott]

@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!