Forum Discussion

BHigh37's avatar
BHigh37
Regular Visitor
6 years ago
Solved

Avoid Summing Values with Duplicate Fields

I've been reading about duplicate values but cannot find what I'm looking for.  I'm tracking stats of sales data in restaurants.  We have various account types that can pay for checks.  I need to tra...
Need Help
amitchandak's avatar
amitchandak
Super User
6 years ago

If you want to show data check level or above

one of the following should work

Sales1 = Max(sales)
New Sales = sumx(values[sales[checks]),Sales1 )

Or 
CALCULATE(sumx((SUMMARIZE(Sales,sales[checks],"s1",SUM(Sales[Sales]))),[s1])

 

Another option is using all except create count rows at check level and divide it

 

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. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners/ba-p/890814
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p/881739
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601