Forum Discussion
How to calculate duplicate based on different column
Hi Anonymous ,
We can update the measure.
Record = COUNTROWS( DISTINCT(SELECTCOLUMNS('Table',"parent",[Parent],"group",[Assignment group])))If the above one can't help you get the desired result, please provide your expected result with backend logic.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Thanks for your reply but that solution not going to work as your doing disticnt only in one column. Let me tell my requirment once again.
| Number | Assignment group | Parent |
| 1 | A | XYZ |
| 2 | B | XYZ |
| 3 | A | XYZ |
Based on the above table either 1 & 2 consider as double or 2 & 3 consider as double. Not 1 & 3
Hi Anonymous ,
We can update the measure.
Record = COUNTROWS( DISTINCT(SELECTCOLUMNS('Table',"parent",[Parent],"group",[Assignment group])))
If the above one can't help you get the desired result, please provide your expected result with backend logic.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.