topic Re: Filter two different tables in DAX Commands and Tips

Filter two different tables

Anonymous — Thu, 04 May 2023 04:30:10 GMT

Hi,

I need some help if it is possible.

I have a table with data like this

Table: data

dataName	info2	info3	policyName
info1.1	info1.2	info1.3	policy1,policy2,policy3
info2.1	info2.2	info2.3	policy2,policy3,policy4

And I have another table.

Table: policyNames

policyName

policy1

policy2

policy3

policy4

And I need to filter selecting from the second one and see how many rows from the table data or the column dataName have in them the selected policy.

Thank you in advance

Re: Filter two different tables

Ashish_Mathur — Thu, 04 May 2023 09:00:38 GMT

Hi,

In the Query Editor, right click on the PolicyName column of the Data Table and select Split Column > By delimiter. Select comma as the delimiter and expand Advanced Options. Select Rows there. Right click on the column and sleect Trim. Create a relationship (Many to One and Single) from the PolicyName column to the PolicyName column of the PolicyNames Table. To your Table visual, drag the PolicyName column from the PolicyNames Table and write this measure

Measure = countrows(Data)

Hope this helps.