Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Use Measure to Count How Many Times Value Appears in Another Column

Hi All, I'm trying to see how often the values in one column appear in another column in a different table, and I need the count to change based on filters.  The below calculated column does the j...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    6 years ago

    hi  Anonymous 

    You could use this formula:

    Measure222 = COUNTROWS(FILTER('Table 1', 'Table 1'[Column A] in VALUES('Table 2'[Column A])))

     

    Regards,

    Lin

     

PaulDBrown's avatar
PaulDBrown
Community Champion
6 years ago

1)Create a new table for unique values in table 1:
Values Table 1 = VALUES(table1[column A])

2) in the modeling pane, create a relationship between the new table and table 2 (if you need to do other calculations involving both tables, also create a relatiosnhip with table 1)

 


3) new measure
Counting Table 2 values = COUNTROWS(table 2)
4) create a table visual with column from “Values Table 1” and the measure [Counting Table 2 values]