The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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)
User | Count |
---|---|
13 | |
8 | |
6 | |
6 | |
5 |
User | Count |
---|---|
24 | |
14 | |
13 | |
8 | |
8 |