The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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 |
---|---|
16 | |
8 | |
6 | |
6 | |
5 |
User | Count |
---|---|
23 | |
13 | |
13 | |
8 | |
8 |