Forum Discussion
Solved
How to count two columns with names without repeating?
Hello, friends. I have a problem. I have a data base of production, and every machine entry I have the name of the operator who was producing on this. But, some days, I have two operator in...
Hi,
In the Query Editor, right click on the Operadores column and select Split column. Split by rows there. Create a Calendar Table and build a relationship from the Data column to the Date column of the Calendar Table. Create a slicer from the Date column of the Calendar Table and select any date there. Write this measure
=DISTINCTCOUNT('Table1'[Operadores])
Hope this helps.
Ashish_Mathur
Super User
Super UserHi,
Did you try my solution?
Hey, Ashish!
It worked!
Thank you so much for the insight!
However, I have to create a copy of the database with only the dates and names of the operators, cause dividing the row, the production column is divided too, like this:
| DATE | OPERATOR | PRODUCTION |
| 16/03 | A , B | 10 |
After dividing:
| DATE | OPERATOR | PRODUCTION |
| 16/03 | A | 10 |
| 16/03 | B | 10 |
But no problem. It's a solution!
Thank you so much.
- Ashish_Mathur
You are welcome.