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!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register 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)
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the September 2025 Power BI update to learn about new features.
User | Count |
---|---|
9 | |
8 | |
6 | |
4 | |
3 |