Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello All -
I am attempting to use a calculated column to identify the duplicate rows with the highest value. I know how to do this in Excel, using the COUNTIFS function, however, I have been struggling to do this in DAX/Power BI.
My sample data looks like,
In another column, I would like to identify the rows that are the duplicates, based on Year.Wk, DriverName, with the highest value in Stops per Week.
The result would look as follows,
Currently, I have the following Calculated Column, which is providing the wrong answer;
Solved! Go to Solution.
Hi @MPICKETT,
Would this work?
Driver Choice = IF ( CALCULATE ( MAX ( 'Driver Relationship Table'[Stops per Week] ), ALLEXCEPT ( 'Driver Relationship Table', 'Driver Relationship Table'[Year.Wk], 'Driver Relationship Table'[DriverName] ) ) = 'Driver Relationship Table'[Stops per Week], 1, 0 )
Best,
Bekah
how is this done in excel?
Hi @MPICKETT,
Would this work?
Driver Choice = IF ( CALCULATE ( MAX ( 'Driver Relationship Table'[Stops per Week] ), ALLEXCEPT ( 'Driver Relationship Table', 'Driver Relationship Table'[Year.Wk], 'Driver Relationship Table'[DriverName] ) ) = 'Driver Relationship Table'[Stops per Week], 1, 0 )
Best,
Bekah
I knew I was overcomplicating things. That did the trick!
Thank you so much Bekah!
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
114 | |
95 | |
86 | |
78 | |
66 |
User | Count |
---|---|
150 | |
118 | |
111 | |
106 | |
95 |