Forum Discussion

RichOB's avatar
RichOB
Icon for Post Partisan rankPost Partisan
1 year ago
Solved

Need help joining a table to filter values as not active

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...
  • mark_endicott's avatar
    1 year ago

    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!