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.
Hi,
I have two columns [Position ID] and [Position Location] in the table 'Position'.
There are some duplicates on the position ID.
I have created a column to count the duplicates for position ID
Duplicated Position_Code =
Var Position_ID = [Position ID]
RETURN
CALCULATE(
COUNTROWS('Position'),
all('Position'),
'Position'[Position ID] = Position_ID
)
The output will show the number of times the Position ID is in the data.
So now I want to check if the duplicated position ID has the same location for each data or not.
This is an example of duplicated position ID data with multiple locations.
Position ID | Position Location | Duplicated Position_ID |
1130 | New York | 3 |
1130 | New York | 3 |
1130 | Ohio | 3 |
1456 | Nashville | 2 |
1456 | Boston | 2 |
So basically the duplicated ID would be
Duplicated Position_ID <> 1
But im not sure how to get that measure.
Can anyone help me with this?
Solved! Go to Solution.
is this what you want?
Column = CALCULATE(COUNTROWS('Table'),FILTER('Table','Table'[Position ID]=EARLIER('Table'[Position ID])&&'Table'[Position Location]=EARLIER('Table'[Position Location])))
Proud to be a Super User!
is this what you want?
Column = CALCULATE(COUNTROWS('Table'),FILTER('Table','Table'[Position ID]=EARLIER('Table'[Position ID])&&'Table'[Position Location]=EARLIER('Table'[Position Location])))
Proud to be a Super User!
It wasnt what I was looking for at first, but I did find it useful and managed to get the output that I want from your solution. Thank youuuu
you are welcome
Proud to be a Super User!
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 |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |