cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

how to count sum value to distinct and sum in total

1.PNG

hi , i wanna count the distinct value , if it is 2 , let transform it to 1 , and sum in the total , while now 2 + 1 + 1 + 2 +..... , therefore i don't know the exact number of distinct customer. 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: how to count sum value to distinct and sum in total

hi, @Chanleakna123 

This looks like a measure totals problem. Very common. See this post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

 

For your case, try this formula logic:

Measure= 
VAR _table=SUMMARIZE(Table,'Table'[Customer Code],'Table'[Customer Name], "_Value",IF([Custom]=1,1,1)) RETURN SUMX(_table,[_Value])

Best Regards,

Lin

Community Support Team _ Lin
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

2 REPLIES 2
tex628 New Contributor
New Contributor

Re: how to count sum value to distinct and sum in total

Could you please post the dax code that you are currently using?

Community Support Team
Community Support Team

Re: how to count sum value to distinct and sum in total

hi, @Chanleakna123 

This looks like a measure totals problem. Very common. See this post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

 

For your case, try this formula logic:

Measure= 
VAR _table=SUMMARIZE(Table,'Table'[Customer Code],'Table'[Customer Name], "_Value",IF([Custom]=1,1,1)) RETURN SUMX(_table,[_Value])

Best Regards,

Lin

Community Support Team _ Lin
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 Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

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.

Users Online
Currently online: 365 members 3,575 guests
Please welcome our newest community members: