Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

DAX SUM of Measure by row with correct Grand Total - then multiply by 0.10

Greetings,

 

   I have the formula below stuffed in to a measure because I wanted the count to be evaluated by row. 

 

 

COUNTAX(DISTINCT(LY_SS_REF[CUSTOMER_NUMBER]),LY_SS_REF[CUSTOMER_NUMBER])

 

 

   I'm trying to get the SUM value of said measure but need to ensure the Grand Totals are correct and then I want to multiply that number (by row) by 0.10.  I've tried every configuration I can think of, have read Greg Deckler's posts and videos but nothing's clicking and I believe I've made more of a mess than anything else.

 

   Here's what I've got.

 

 

Distinct # of SSIncrease2:=SUMX(LY_SS_REF,COUNTAX(DISTINCT(LY_SS_REF[CUSTOMER_NUMBER]),LY_SS_REF[CUSTOMER_NUMBER])*.1)

 

 

   Assistance/Wisdom is much appreciated. 🙂

1 REPLY 1
amitchandak
Super User
Super User

@Anonymous , Try like

 

Distinct # of SSIncrease2:=SUMX(Values(LY_SS_REF[CUSTOMER_NUMBER]),calculate(COUNTAX(values(LY_SS_REF[CUSTOMER_NUMBER]),LY_SS_REF[CUSTOMER_NUMBER]))*.1)

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.