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.
Can you apply the same filter to the big table as to the summary table?
You might need to define a measure and drag that into the filters pane for that visual.
Cantidad = COUNTROWS ( ALLEXCEPT ( Table1, Table1[ClientID] ) )For a strange reason, by doing that, putting the filter, or doing it with a dax measurement, it does not filter what I want to see, but it distorts the information. I was thinking of making a calculated field from the table where I capture the information, but I can't do it either. Here's an example of what I'm trying to do:
NISRAD Calculated field 123 2 123 2 125 2 125 2 In my data table the customer number appears as NISRAD, and on the right, calculated field, is what I intend to do. I want the calculated field column to count how many times the customer number was found. For example, 123 is 2 times, I want you to place me 2. I tried the count function, but it doesn't work for me for this. How can I do? My table is called "OS Pending" and the field I want to count "NISRAD".
Yeah, you could try a calculated column instead of a measure.
Cantidad = COUNTROWS ( FILTER ( 'OS Pending', 'OS Pending'[NISRAD] = EARLIER ( 'OS Pending'[NISRAD] ) ) )