Forum Discussion
Solved
Remove duplicates based on values
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 anoth...
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.
