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.
Hey,
So I'm trying to figure out how to create the fourth column 'ResultMatch' as seen in the table below. What I need this column to return is whether or not multiple ID's share the same 'Value1' and 'Value2' combination. So because ID 1 and 4 share the same Value 1 + Value 2 combination, 1 is returned, and for the ID's whose values don't match anyone else, they receive a 0.
Any help would be much appreciated.
Table1:
ID | Value1 | Value2 | ResultMatch |
1 | 1000 | 350 | 1 |
1 | 1000 | 350 | 1 |
2 | 1200 | 600 | 0 |
2 | 1200 | 600 | 0 |
3 | 720 | 120 | 0 |
3 | 720 | 350 | 0 |
3 | 720 | 350 | 0 |
4 | 1000 | 350 | 1 |
4 | 1000 | 350 | 1 |
Solved! Go to Solution.
This should work as a column or measure:
Column = VAR __table = FILTER(ALL('Table6'),[Value1]=EARLIER([Value1]) && [Value2]=EARLIER([Value2]) && [ID]<>EARLIER([ID])) VAR __count = COUNTROWS(__table) RETURN IF(ISBLANK(__count),0,1)
This should work as a column or measure:
Column = VAR __table = FILTER(ALL('Table6'),[Value1]=EARLIER([Value1]) && [Value2]=EARLIER([Value2]) && [ID]<>EARLIER([ID])) VAR __count = COUNTROWS(__table) RETURN IF(ISBLANK(__count),0,1)
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 |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |