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  