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] ) ) )
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] ) ) )