Hi@Mariette,
Do you mean that there are duplicated column in different SP lists?
I do not know how many duplicated columns in all, however, you should handle the duplicated column from different SP lists by creating a collection.
You could combine all the duplicated columns in a same collection and distinct the target column, and then put the count rows number into the Sum() function.
For example, create a collection that combine all the SP lists containing the same column like clientnumber as below:
Collect(ComCol,{Value:Genre.Genre},{Value:MeType.Genre})
And then do the counting by setting the Label Text property as below:
CountRows(Distinct(Ungroup(ComCol,"Value"),Genre))
Finally you could put the above CountRows() formula into the Sum() function.
What's more, please try to give all the detailed information at the very beginning so that I could help you get there ASAP.
Regards,
Qi
