Calculate distinct count of a column per day in date column in power BI

[erp]

I have a datetime column and No column with repeated values in both. I need to calculate distinct count of No per day.

Here is my sample data

So I need Distinct count of bomno column with respect to date 23-06-2021.

Thanks in Advance...

[v-deddai1-msft · Accepted solution]

Hi @erp ,

You can use something like:

measure = CALCULATE(DISTINCTCOUNT(Table[bomno]),FILTER(ALL(Table),Table[lastdate].[Date] = Date(2021,6,23)))

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[daxer-almighty]

https://dax.guide/distinctcount