Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
need help with my DAX formula. I currently have the table and DAX formula below, to get the cummulative figures for column B. It works fine. But i would like to only add the values where column D is "ongoin". How do i add that to the formula?
Current DAX:
calculate(sum(table1[rowcountpart]), FILTER (ALL(Table1), Table1[A10] <= MAX (Table1[A10])
Table1
A | B | C | D |
ID | row count part | A10 | Status |
A | 10 | 2022-04-01 | Ongoing |
B | 5 | 2022-04-02 | Dropped |
C | 4 | 2022-04-03 | Ongoing |
D | 3 | 2022-04-04 | Ongoing |
E | 2 | 2022-04-05 | Dropped |
F | 1 | 2022-04-06 | Ongoing |
Thanks in advance, BR rookie Patrik
Solved! Go to Solution.
Oh sorry, now I understood.
So the measure for the cumulative sum would be:
CALCULATE(SUM(table1[rowcountpart]), FILTER(ALL(Table1), Table1[A10] <= MAX(Table1[A10])&& Table1[Status]="Ongoing"))
Then just create the line chart with A10 in the X-Axis and the Measure in the Values.
Can you tell me what did you want to archieve with this part: "Table1[A10] <= MAX (Table1[A10]"?
I would do this: CALCULATE(SUM(table1[rowcountpart]), FILTER (ALL(Table1), Table1[Status] = "Ongoing"))
Not, really. (I got this from a collegue). What I want is the cummulative figure of all in column B, displayed as a line chart over time for column C (A10). Where A10 is on the X-axis.
Does that makes any sense?
Oh sorry, now I understood.
So the measure for the cumulative sum would be:
CALCULATE(SUM(table1[rowcountpart]), FILTER(ALL(Table1), Table1[A10] <= MAX(Table1[A10])&& Table1[Status]="Ongoing"))
Then just create the line chart with A10 in the X-Axis and the Measure in the Values.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |