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

Anonymous
Or as an alternative (no need to create a new table) you can try:
Measure = CALCULATE(COUNTROWS(table 2), TREATAS(VALUES(table 1 [column A]), table 2 [column A]))

 

and include the field "table 1 [column A]" in your table.