The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now
Hi!
I'm trying to find a DAX wherein I can find a duplicate values and mark the duplicate values as Zero. Here's the sample table in excel.
Invoice # | How many Duplicates? | Desired Output |
1234 | 2 | 1 |
5678 | 2 | 1 |
1234 | 2 | 0 |
3891 | 1 | 1 |
9876 | 1 | 1 |
5678 | 2 | 0 |
As you can see Invoice # 1234 and 5678 have duplicates. I need the desired output column wherein the original invoices are tag as 1 and the duplicates are 0.
Solved! Go to Solution.
1) You need to create an index column.
2) write such a measure.
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
https://1drv.ms/u/s!AiUZ0Ws7G26Rhl_I6iKctqi_y6pB?e=EdSNHC
Hi @Ahmedx , it worked 🤗 Thank you so much for your help and effort. You saved my life. 😅
1) You need to create an index column.
2) write such a measure.
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
https://1drv.ms/u/s!AiUZ0Ws7G26Rhl_I6iKctqi_y6pB?e=EdSNHC
User | Count |
---|---|
158 | |
109 | |
96 | |
83 | |
75 |
User | Count |
---|---|
154 | |
137 | |
131 | |
81 | |
62 |