Forum Discussion

Glenda's avatar
Glenda
Icon for Helper I rankHelper I
5 years ago

Filtering Table to only records which contain Text from another Table

Hi All,    I have 2 tables one with records of injuries and one with Body Parts. I need to count the number of time a body part is in the injury record table. Which I have done using the formula be...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Glenda , Try a measure like

 


Count DX v2 =
CALCULATE(countx(values('Injury'),'Injury'[Record No.]),
FILTER('Injury',
CONTAINSSTRING('Injury'[Key Phrase],MAX('Body Location'[Body Part]))))

Glenda's avatar
Glenda
Icon for Helper I rankHelper I
5 years ago

That is what I did but due to the size of my injury table (350,000), the measure is really slow. So I am trying to filter the table down first as only about 40,000 records actually have body parts.