Forum Discussion
Measure to count where value appears in another table and using a filter for containsstring
Dali7 , Ensure that there is a relationship between Table 1 and Table 2 based on the Technical Service column.
Then use DAX to create a measure that counts the incidents where the Technical Service in Table 1 is also in Table 2 and the Title contains the word "Freeze".
DAX
Count of Freeze =
CALCULATE(
COUNTROWS('Table 1'),
FILTER(
'Table 1',
'Table 1'[Technical Service] IN VALUES('Table 2'[Technical Service]) &&
CONTAINSSTRING('Table 1'[Title], "Freeze")
)
)
Super UserDali7 , Ensure that there is a relationship between Table 1 and Table 2 based on the Technical Service column.
Then use DAX to create a measure that counts the incidents where the Technical Service in Table 1 is also in Table 2 and the Title contains the word "Freeze".
DAX
Count of Freeze =
CALCULATE(
COUNTROWS('Table 1'),
FILTER(
'Table 1',
'Table 1'[Technical Service] IN VALUES('Table 2'[Technical Service]) &&
CONTAINSSTRING('Table 1'[Title], "Freeze")
)
)
bhanu_gautam OMG thank you so much for such a quick response and it has worked perfectly, it was the IN VALUES that I wasn't familar with and that I was struggling with, thanks again.
