Forum Discussion
RichOB
Post Partisan
Post PartisanNeed 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...
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!
Ashish_Mathur
Super User
Super UserHi,
Assuming there is a relationship (Many to One and Single) from Table2 to Table1, to your Table visual, drag Countries from Table1 and write this measure
Measure = calculate(countrows(Data),Data[Decommissioned_Date]=blank())
Hope this helps.