Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
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)
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 8 | |
| 5 | |
| 4 | |
| 3 | |
| 3 |
| User | Count |
|---|---|
| 24 | |
| 12 | |
| 11 | |
| 9 | |
| 8 |