Counting Suppliers depending on the Planner Counting with DAX

[Anonymous]

Hello, I have a table like this: 

Table 1 

I have different Planners and they have used different suppliers. I want to count the unique Suppliers depending on the Planner.

My Target is to get the following Output:

Tabelle2

I need to count unique suppliers by Planner. I am doing this in DAX

Thanks in advance. 

Table 1 

Planner             Supplier

1                       Müller

1                       Siemens

1                       Siemens 

2                       Müller

3                       Siemens

3                       Müller 

3                        Müller

3                        Müller 

4                        Siemens

4                         Koch 

Table 2 

planner         Diffrent Supplier used

1                    2

2                    1

3                    2

4                    2

[Anonymous · Accepted solution]

Hi  @Anonymous ,

Here are the steps you can follow：

1. Create calculated table.

Table 2 =
SUMMARIZE(
    'Table',
    'Table'[Planner],
    "Dirrent Supplier used",
    CALCULATE(
        DISTINCTCOUNT('Table'[Supplier])))

2. Result:

Best Regards,

Liu Yang

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

[tamerj1]

Hi @Anonymous 

Have you tried DISTINCTCOUNT ( 'Table'[Supplier] )?