Help Grouping Counts by Company

[GlitchedDuck]

Hi all,

I'm working on a dashboard to show live suppliers and want to show in a card how many suppliers are live in the database based on a count of invoices. i've added some data to show what i'm working with. So with this i want to show Company 1 ( 1 Live Supplier ) Company 2 ( 2 Live Suppliers ) and Company 3 ( 2 Live Suppliers )

Name	Invoices	Organization
Apple	189	Company 1
Microsoft	24	Company 2
Facebook	146	Company 3
SAS	23	Company 2
Oracle	24	Company 3
Dell	0	Company 3

[v-yanjiang-msft · Accepted solution]

Hi @GlitchedDuck ,

According to your description, I create a sample.

Here's my solution, create a measure.

Count =
CALCULATE (
    DISTINCTCOUNT ( 'Table'[Name] ),
    FILTER (
        ALL ( 'Table' ),
        'Table'[Organization] = MAX ( 'Table'[Organization] )
            && SUMX (
                FILTER (
                    ALL ( 'Table' ),
                    'Table'[Organization] = EARLIER ( 'Table'[Organization] )
                        && 'Table'[Name] = EARLIER ( 'Table'[Name] )
                ),
                'Table'[Invoices]
            ) > 0
    )
)

Get the correct result.

I attach my sample below for reference.

Best Regards,
Community Support Team _ kalyj

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

[SergioSilvaPT]

@GlitchedDuck ,

Adding the individual invoice it will always show one supplier per line, as one invoice can only have one supplier.

You can force the measure to ignore the invoice in the filtering and show the global suppliers per Organization:

Count of Name = CALCULATE(
            COUNT('Table'[Name]),
            ALL('Table'[Invoices]
            ))

Giving something like this:

Regards,

Sérgio Silva 

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

[SergioSilvaPT]

Hi @GlitchedDuck ,

You only need to create a measure with the following:

Count of Name = COUNT('Table'[Name])

And put the organization and the measure in a table:

Regards,

Sérgio Silva 

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

[GlitchedDuck]

Thanks for the reply, i should of said in my data its shows each indiviual invoice so the count shows Company 1 as 189, but if i group it name it gives me the table above