Forum Discussion
Distinct counting with conditions
Hello, Hopefully someone can help me. I need to distinct count with a condition. I have a list of sellerID, a list of products and a date. Basically i want to know how many different...
can you please try this and check if it is working
Measure = CALCULATE(DISTINCTCOUNT('Table'[SellerId]),OR('Table'[Product] = "apple",'Table'[Product]="banana"))
- AlB
Community Champion
That should work. It's equivalent to (although less versatile than) my first solution. You can check it yourself
