filter in Measure by matching two columns from different table's

[Anonymous]

Dear All ,

I have created a measure but l stucked to filter in a measure 

eg:Condition as 1.In INDEX table if mapping=PTP/OTC Timelines comes   then has to pick all the values in description and have to match with Task of data table.

2.then this filteres need to keep in measure level.

Thanks in Advance.

Best Wishes,

Younis

[Anonymous]

@amitchandak @zornstv @mwegener 

[mwegener]

Hi @Anonymous ,

could you post a screenshot of your model view?

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.

[Anonymous]

Hi @mwegener 

please find the Attached Data Table and index table Data model

task should be equal to description based on mapping column on Measure

[mwegener]

Hi @Anonymous ,

did you create a relation between Tast and Description?

[Anonymous]

Hi @mwegener ,

yeah i have created a relation ship

[mwegener]

Hi @Anonymous ,

what happens to the measure if you filter by the column "Mapping"?

[Anonymous]

Hi @mwegener 

As I am New to Power BI, I am Unaware of logic. Bascically if Index[mapping]="PTP/OTC Timelines" then it has to pick all values from index[Description] then this values should be filtered on measure

[mwegener · Accepted solution]

Hi @Anonymous ,

that should be the case with the relationship.

It would be better if the relationship was a "many to one (*: 1)" relationship that only filters in one (single) direction.

But it should work that way.

[Anonymous]

Thank you @mwegener  
Now It Works After Activation relationship.