Complex card coming for double distincount

[Flavio2021]

Hi could be that is only for me complex, but the result that I would is

Starting from a table were I have several s/n and several ticket of assistance unique, I would like to got the number of all the s/n that have more of 1 ticket of assistance opened

Suggestion ??

[amitchandak · Accepted solution]

@Flavio2021 , Create a new measure like

countx(filter(summarize(Table, Table[Serial Number], "_1", distinctCOUNT(Table[Assitance])), [_1]>1),[Serial Number])

[v-stephen-msft · Accepted solution]

Hi @Flavio2021 ,

Create the following two measures

Measure = CALCULATE(COUNT('Table'[Assistance]),ALLEXCEPT('Table','Table'[Serial number]))

S/n with more of 1 ticket = CALCULATE(DISTINCTCOUNT('Table'[Serial number]),FILTER(ALL('Table'),[Measure]>1))

Best Regards,

Stephen Tao

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

[amitchandak · Accepted solution]

@Flavio2021 , Create a new measure like

countx(filter(summarize(Table, Table[Serial Number], "_1", distinctCOUNT(Table[Assitance])), [_1]>1),[Serial Number])