Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I have this table,
but the total is wrong (its missing the 120 +120 to equal 3205 for Tax Place holder and 2592 for Cash Place holder)
My measures are:
and
Date | Taxes |
10/2/2016 0:00 | 635.802 |
10/3/2016 0:00 | 649.527 |
10/6/2016 0:00 | 827.314 |
10/4/2016 0:00 | 852.5352 |
Solved! Go to Solution.
Hi @Anonymous
create measures
blank_flag = IF(SUM('Pi Data'[Taxes])=BLANK(),1,0) Tax Place Holder2 = VAR count_blank = COUNTX ( FILTER ( ALLSELECTED ( 'date' ), [blank_flag] = 1 ), [blank_flag] ) VAR tax1 = IF ( ISBLANK ( SUM ( 'Pi Data'[Taxes] ) ), 5 * 24, SUM ( 'Pi Data'[Taxes] ) ) RETURN IF ( HASONEVALUE ( 'date'[Date] ), tax1, CALCULATE ( SUM ( 'Pi Data'[Taxes] ), ALLSELECTED ( 'date'[Date] ) ) + 120 * count_blank ) Cash Place Holder2 = var sum1=18*24 return IF(HASONEVALUE('date'[Date]),sum1,SUMX(ALLSELECTED('date'),sum1))
Best Regards
Maggie
Hi @Anonymous
create measures
blank_flag = IF(SUM('Pi Data'[Taxes])=BLANK(),1,0) Tax Place Holder2 = VAR count_blank = COUNTX ( FILTER ( ALLSELECTED ( 'date' ), [blank_flag] = 1 ), [blank_flag] ) VAR tax1 = IF ( ISBLANK ( SUM ( 'Pi Data'[Taxes] ) ), 5 * 24, SUM ( 'Pi Data'[Taxes] ) ) RETURN IF ( HASONEVALUE ( 'date'[Date] ), tax1, CALCULATE ( SUM ( 'Pi Data'[Taxes] ), ALLSELECTED ( 'date'[Date] ) ) + 120 * count_blank ) Cash Place Holder2 = var sum1=18*24 return IF(HASONEVALUE('date'[Date]),sum1,SUMX(ALLSELECTED('date'),sum1))
Best Regards
Maggie
Thanks! it works. Crazy that it needs to be that complicated haha!!
User | Count |
---|---|
124 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |