Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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. 🙂
@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)
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 12 | |
| 9 | |
| 9 | |
| 5 | |
| 4 |
| User | Count |
|---|---|
| 27 | |
| 22 | |
| 20 | |
| 18 | |
| 12 |