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.
Hello guys,
Basically I need a TOTAL that is actually a SUM of the CUMULATIVE SUM of a measure I made.
As you can see in the table above the TOTAL is actually the last value I have, I understand the reason for this and I know that this is the correct total but for the purpose I need I have to add up all the values for each month, no it needs to be in this total field of the table actually for me it would be even better to put the TOTAL on a card.
Cumulative by Month = Calculate(Count('resources'[id]), FILTER(ALL('Calendar'), 'Calendar'[Date] <= MAX('Calendar'[Date]))) * Calculate(COUNT(order[id])* MIN(Costs[Cost]), Filter(ALLSELECTED('Calendar'), 'Calendar'[Date] <= MAX('Calendar'[Date])))
Solved! Go to Solution.
@rodrigonogueir4 , Try like
sumx(Values('Calendar'[month year]) ,Cumulative by Month = Calculate(Count('resources'[id]), FILTER(ALL('Calendar'), 'Calendar'[Date] <= MAX('Calendar'[Date]))) * Calculate(COUNT(order[id])* MIN(Costs[Cost]), Filter(ALLSELECTED('Calendar'), 'Calendar'[Date] <= MAX('Calendar'[Date]))) )
@rodrigonogueir4 , Try like
sumx(Values('Calendar'[month year]) ,Cumulative by Month = Calculate(Count('resources'[id]), FILTER(ALL('Calendar'), 'Calendar'[Date] <= MAX('Calendar'[Date]))) * Calculate(COUNT(order[id])* MIN(Costs[Cost]), Filter(ALLSELECTED('Calendar'), 'Calendar'[Date] <= MAX('Calendar'[Date]))) )
User | Count |
---|---|
14 | |
8 | |
6 | |
6 | |
5 |
User | Count |
---|---|
23 | |
14 | |
13 | |
8 | |
8 |