Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am very new to BI and i am tying myself in knots.
I have the following set of data:
I have to filter the set so anything with a Service_ID equal to 133 or 134 is kept
If another row has a Service_id is 133 or 134 but the Event_id is equal to a row with the same Event_id and an invalid service_id this row is also Filtered out. So the data should look like the following:
I can filter down but cannot work out the syntax to evaluate
Hope this explains
regards
Solved! Go to Solution.
I believe what you want is something like:
Measure 6 = VAR __eventID = MAX([Event_ID]) VAR __table = ADDCOLUMNS('Table4',"__count",COUNTX(FILTER(ALL('Table4'),[Event_ID] = EARLIER([Event_ID]) && [Service_ID]<>133 && [Service_ID]<>134),[Service_ID])) RETURN IF(SUMX(__table,[__count]) = 0,1,0)
See Page 6, Table4
I believe what you want is something like:
Measure 6 = VAR __eventID = MAX([Event_ID]) VAR __table = ADDCOLUMNS('Table4',"__count",COUNTX(FILTER(ALL('Table4'),[Event_ID] = EARLIER([Event_ID]) && [Service_ID]<>133 && [Service_ID]<>134),[Service_ID])) RETURN IF(SUMX(__table,[__count]) = 0,1,0)
See Page 6, Table4
thanks for that. it done what I required.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |