cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Frequent Visitor

## Complex card coming for double distincount

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 ??

2 ACCEPTED SOLUTIONS
Super User

@Flavio2021 , Create a new measure like

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

Community Support

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.

2 REPLIES 2
Community Support

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.

Super User

@Flavio2021 , Create a new measure like

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

Announcements

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors