cancel
Showing results for
Did you mean:
Member

## Formulas

I need your help to solve a problem. I have tried various solutions that I have read on the forums but that does not help me.

I have this kind of data :

Several references belonging to the same team and with the same number.

Dont add all numbers but only 1 times by ID

And I would like to get this kind of results via a matrix.

2 ACCEPTED SOLUTIONS

Accepted Solutions
Moderator

## Re: Formulas

Hi @Milozebre,

You can create a calculated table to list all distinct ID, Team values:

Table = SUMMARIZE('Table1',Table1[ID],'Table1'[Team],"Value",MAX('Table1'[NUMBER]))

Then drag that [ID] and [Team] to matrix Row group, [Value] to Values.

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super Contributor

## Re: Formulas

Another option is to use the Query Editors remove duplicates function. Just select the 4 columns and click remove duplicates

Proud to be a Datanaut!

7 REPLIES 7
Super User

## Re: Formulas

Hi @Milozebre,

Do a distincr count on ID and you will get what you need.

Regards,

MFelix

Proud to be a Datanaut!

Member

## Re: Formulas

HI MFelix,

I have already tried but it doesn't work.

Super User

## Re: Formulas

The distinct count was done in the ID column or on the nber column?

Proud to be a Datanaut!

Moderator

## Re: Formulas

Hi @Milozebre,

You can create a calculated table to list all distinct ID, Team values:

Table = SUMMARIZE('Table1',Table1[ID],'Table1'[Team],"Value",MAX('Table1'[NUMBER]))

Then drag that [ID] and [Team] to matrix Row group, [Value] to Values.

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super Contributor

## Re: Formulas

Another option is to use the Query Editors remove duplicates function. Just select the 4 columns and click remove duplicates

Proud to be a Datanaut!

Member

## Re: Formulas

This is exactly the result I was hoping for.

I realize that I still have some way to go

A big thank-you

Member

## Re: Formulas

Two solutions

I am a taker because I am fond of learning and I realize that with the many features of Power Bi and DAX, I have enough to take care of for a long time

Thank you

Announcements

#### Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

#### Community News & Announcements

Get your latest community news and announcements.

#### Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Top Kudoed Authors
Users Online
Currently online: 55 members 1,221 guests
Recent signins: