cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
laitung1991 Frequent Visitor
Frequent Visitor

DISTINCT AND SUM MULTIPLE

I have table and i want to create maxtrix in visualizations 

Capture.PNG

with row of matrix table is NAME and value sum of amount with distinct ID and result :

NAME   AMOUNT

A          500

B          1100

but i effort write DAX but not result so i wish you guide me.

Thanks you

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: DISTINCT AND SUM MULTIPLE

Hi laitung1991,

You could try to use below measure to see whether it works or not

Measure =
SUMX (
    SUMMARIZE ( T3, T3[name], T3[id], T3[amount], "sumdistinct", T3[amount] ),
    [sumdistinct]
)

419.PNG

Best Regards,
Zoe Zhi

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

View solution in original post

3 REPLIES 3
amitchandak Super Contributor
Super Contributor

Re: DISTINCT AND SUM MULTIPLE

This seems like the sum of the Averages problem.  Please, ref the link below. Do count distinct  in place of Avg

 

https://community.powerbi.com/t5/Desktop/SUM-of-AVERAGE/td-p/197013

 

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.

laitung1991 Frequent Visitor
Frequent Visitor

Re: DISTINCT AND SUM MULTIPLE

i don't think so, i want just sum not average, the example is created by data raw about 100.000 record and have many diffirence value

Community Support Team
Community Support Team

Re: DISTINCT AND SUM MULTIPLE

Hi laitung1991,

You could try to use below measure to see whether it works or not

Measure =
SUMX (
    SUMMARIZE ( T3, T3[name], T3[id], T3[amount], "sumdistinct", T3[amount] ),
    [sumdistinct]
)

419.PNG

Best Regards,
Zoe Zhi

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

View solution in original post

Helpful resources

Announcements
Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 416 members 4,252 guests
Please welcome our newest community members: