DistinctCount ONLY the lowest values of a column in case of multiple rows

[FVZ]

I'm looking for a DAX calculation which does DISTINCTCOUNT with a certain condition. If a Customer has two different Priorities, it should only do a count on the lowest Priority. To demonstrate with dummy data:

Customer Priority

Jan	5
Tom	2
Dirk	6
Jan	1

You see that Customer Jan has two rows, one with Priority 5 and 1. In this case I want to DISTINCTCOUNT the Customer only for the lowest Priority, being 1 in this case. The end result should look as follows. 

Thanks in advance!!

[shafiz_p · Accepted solution]

Hi @FVZ  Try this:

DistinctCountLowestPriority = 
CALCULATE(
    COUNT('Table'[Customer]),
    FILTER(
        'Table',
        'Table'[Priority] = CALCULATE(MIN('Table'[Priority]), ALLEXCEPT('Table', 'Table'[Customer]))
    )
)

Output:

Hope this helps!!

If this solved your problem, please accept it as a solution and a kudos!!

Best Regards,
Shahariar Hafiz

[FVZ]

Had to change COUNT to DISTINCTCOUNT but worked like a charm, thank you sir!

[johnt75]

Just do a distinct count of the customer, that will only count them once no matter how many times they appear in the table.

[FVZ]

That's the thing, I don't want to just do a Distinct Count of the Customer because then a Customer with two rows will be counted twice (in this case in Priority 5 and 1). While I only want it to be counted once, for the lowest Priority (1). 

[johnt75]

That's not how a distinct count works, that's how a count works. A count would return 2 for a customer with 2 rows, a distinct count will only return 1 for a customer no matter how many times they appear.

[FVZ]

That's true yes. But as I said, I want to return 1 for a Customer which appear twice in the data (in Priority 5 and 1). Distinct Count returns a 1 for both the Priorities, but I only want to return it for the lowest Priority. So not with Priority 5.