Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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.
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.
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
Hi @Anonymous ,
did you create a relation between Tast and Description?
Hi @Anonymous ,
what happens to the measure if you filter by the column "Mapping"?
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
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.
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |