cancel
Showing results for
Did you mean:
Post Prodigy

## how to count sum value to distinct and sum in total

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
Community Support

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.
2 REPLIES 2
Community Support

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.
Super User II

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

Announcements

#### Welcome to the User Group Public Preview

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

#### Microsoft Business Applications Summit sessions

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

#### Claim Your Badge & Digital Swag!

Check out how to claim yours today!

#### Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors
Top Kudoed Authors