Forum Discussion
True Unduplicated
I am attempting to count unique items. I would also like to break them down in a clustered bar chart. My approach has been this: 1. Create a measure called Unique Items = DISTINCTCOUNT('Table'...
UPDATE - 2/18/2025
Adding source data for my Power BI report
| CATEGORY | ITEM | ID |
| CAT1 | SHOES | 1 |
| CAT1 | SOCKS | 2 |
| CAT2 | SHIRT | 3 |
| CAT2 | PANTS | 4 |
| CAT1 | PANTS | 4 |
I'm also attaching a screenshot of the data since the preview is showing the above table looking odd.