Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all,
I need an little help with my DAX formula.
In short: I need a running total of a measure I have created. The measure I have created calculates the monthly fee for a specific date, month or year. But what I want to know is "what is the total fee from the first of March to the end of this month?"
In depth:
I have multiple accounts (salesforce) with a single value on it as monthly fee. It's a static value with no date or whatsoever.
Accoutname | Monthly fee |
Account1 | 100 |
Account2 | 120 |
Account3 | 110 |
Account4 | 105 |
To calculate the total monthly fee for each month, I created this measure which works fine (relationships are DateTable - opportunity and opportunity - account) This returns every date, month or year the same value as intended (435):
Month | Monthly fee |
March | 435 |
April | 335 |
May | 215 |
June | 215 |
The final point, referring to my question, I unable to do the cummulative calculation of the outcome of the measure. So I want to have a card which shows me the total earned fee to the end of this month.
With these numbers, it should be (435 + 335 + 215 + 215) = 1200
Who can help me fixing the last part?
Thanks in advance!
Solved! Go to Solution.
Hi @Anonymous ,
Try using this measure:
Fee(fixed)= SUMX(VALUE(Month), [VAR_var2])
Hi @Tanushree_Kapse ,
Yes! this works! Thanks.
The first measure (measure 1) which ends like:
Return
_var1 - _ var2
then I created a second measure with your solution
Measure 2 = SUMX(VALUES(Dates[YearMonth]), measure1)
Hi @Anonymous ,
Try using this measure:
Fee(fixed)= SUMX(VALUE(Month), [VAR_var2])
User | Count |
---|---|
41 | |
27 | |
23 | |
19 | |
16 |
User | Count |
---|---|
55 | |
35 | |
21 | |
18 | |
15 |