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

     

v-lili6-msft's avatar
v-lili6-msft
Community Support
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

 

jenn93g's avatar
jenn93g
New Member
4 years ago

I attempted to use this, however it did not bring back the total amount of times the value appeard in the second table.