One client, one product, different suppliers - how to count

[Anonymous]

Hello community members,

I have the following issue.

A client (column A) can receive a product (column B) from a supplier (column C)

Column D and E are combinations of column A and B or column A, B and C

ClientNumber	Product	Supplier	ClientProdCombi	ClientProdSupplierCombi
90	55A07	33330618	000090&&55A07	000090&&55A07&&33330618
90	55A07	33330618	000090&&55A07	000090&&55A07&&33330618
245	55A07	84840717	000245&&55A07	000245&&55A07&&84840717
245	55A07	84840717	000245&&55A07	000245&&55A07&&84840717
245	55A07	33330618	000245&&55A07	000245&&55A07&&33330618
720	55A07	84840717	000720&&55A07	000720&&55A07&&84840717
720	55A07	84840717	000720&&55A07	000720&&55A07&&84840717
720	55A07	84840717	000720&&55A07	000720&&55A07&&84840717
730	55A07	84840717	000730&&55A07	000730&&55A07&&84840717
730	55A07	15081473	000730&&55A07	000730&&55A07&&15081473
1357	55A07	33330618	001357&&55A07	001357&&55A07&&33330618
1357	55A07	84840717	001357&&55A07	001357&&55A07&&84840717

Now I would like to know the following thing:  

How many clients have received a specific product from different suppliers?

E.g. client 1357 has received the same product (55A07) from supplier 33330618 and supplier 84840717

Can anyone help me with the measure ?

Hope to hear soon from you!

Best regards,

Sander

[timg · Accepted solution]

Hi Sander,

This kinda depend on what you are looking for in the output. If you just want to have the number of suppliers that every customer+product has, you could try this:

CALCULATE(DISTINCTCOUNT('Table'[Supplier]); ALL('Table'[Supplier]))

If you would like to have a text displayed to indicate whether the client+product has >1 supplier you could try this:

DistinctSuppliers =
IF (
    CALCULATE ( DISTINCTCOUNT ( 'Table'[Supplier] ); ALL ( 'Table'[Supplier] ) ) > 1;
    "Multiple suppliers";
    "One supplier"
)

Regards,

Tim