Forum Discussion
Working with duplicate values
Yeah, you could try a calculated column instead of a measure.
Cantidad = COUNTROWS ( FILTER ( 'OS Pending', 'OS Pending'[NISRAD] = EARLIER ( 'OS Pending'[NISRAD] ) ) )
You restated your problem but didn't really answer either of my questions.
It sounds like you are not working in the Power Query Editor but I'm still not sure what your final result should look like. Are you trying to create a new visual or filter an existing one (or something else like creating a calculated table)? If you want a new visual, what should it look like? Your summary table already shows what customers have duplicates, so I'm assuming you want it to show something other than just customer.
Thank you for your help and for your time my friend. I will try to explain better and place images of my gdp in one go.
This is my summary table. Through the report it was discovered that there were customers (customer numbers) who had more than one order generated. So far so good.
If I select the customer number or quantity it shows me (in another table) more details of that client. In this way:
All correct so far, the problem arises when in the table on the left (summary table) there is no filter:
The detail table (last photo) shows me all the clients (customer number) without exception, and I do not want to see all the clients, I just want to see the clients (customer number) who have more than one work order (NUM_OS). I want in some way, to be able to apply some filter where in the detail table only shows the clients who have more than one work order. I don't know if it is necessary to create another table, or some query, or add more fields that help me achieve it. Just like the summary table, which only shows the clients I need (it has filter applied to show those who have more than one work order), do it also in the detail table, which without applying any filter, only shows me information that I need.