cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Chanleakna123
Post Prodigy
Post Prodigy

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
v-lili6-msft
Community Support
Community Support

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
v-lili6-msft
Community Support
Community Support

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

tex628
Super User II
Super User II

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


Connect on LinkedIn

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors