Forum Discussion

Seb_89's avatar
Seb_89
Frequent Visitor
2 years ago

DISTINCTCOUNT for invoice (context)

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

 

InvoiceNameWhat to do
a1Kamila
a1łukaszc
a1Agatab
b2Kamilb
b2łukaszb
c3Agatab
c3łukaszb
d4Agatab
 
 

 

 

Need Help

4 Replies

  • nirali_arora's avatar
    nirali_arora
    Resolver II
    2 years ago

    You have to add other columns to the measure too 

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

  • Seb_89's avatar
    Seb_89
    Frequent Visitor
    2 years ago

    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.