DISTINCTCOUNT for invoice (context)

[Seb_89]

Hi,

I wloud like to have DISTINCTCOUNT for Invoce from coum name

I'm using this masure

Miara = CALCULATE(DISTINCTCOUNT(Sheet1[Name]))

And sems working

But when i put more columns is not For a1 i should still keep 3  DISTINCT

Thas my data

Invoice	Name	What to do
a1	Kamil	a
a1	łukasz	c
a1	Agata	b
b2	Kamil	b
b2	łukasz	b
c3	Agata	b
c3	łukasz	b
d4	Agata	b

[Anonymous]

Hi @Seb_89 ,

Please refer to my pbix file to see if it helps you.

Create a measure.

Measure =
CALCULATE (
    COUNT ( 'Table'[Invoice] ),
    FILTER (
        ALL ( 'Table' ),
        'Table'[Invoice] = SELECTEDVALUE ( 'Table'[Invoice] )
    )
)

Or a column.

Column =
CALCULATE (
    COUNT ( 'Table'[Invoice] ),
    FILTER ( 'Table', 'Table'[Invoice] = EARLIER ( 'Table'[Invoice] ) )
)

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

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

[Seb_89]

i dont now i was clear.

I need to show for a1 = 3

Like this

But when i add next column in visualisation i have something diffrent.

as i said for a1 i need 3

[nirali_arora]

You have to add other columns to the measure too 

Miara = CALCULATE(DISTINCTCOUNT(Sheet1[Name]), Sheet1[Column1], Sheet1[Column2], Sheet1[Column3])

[Seb_89]

I add but dont working