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.
Hello Forum members,
I am new to Power BI reporting & creating DAX formulas to produce some reporting. With that said we would like to create a Cumulative stack column chart based on weekly progress using column “Class” as legend, “Week of Year” on the Axis and value based on “ID ” row count in Implementation table.
I've search similar Cumulative examples posted within this forum but unlucky for me those solutions found does not seems to work for my situation.
Any help or advice would be greatly appreciated,
Thanks you
Don
ID | Class | SCHEDULED_END_DATE | Week of Year | Year |
61488 | Approved | 9/11/2019 0:00 | 37 | 2019 |
61381 | Rejected | 10/13/2019 0:00 | 42 | 2019 |
61485 | Hold | 3/10/2019 0:00 | 11 | 2019 |
61345 | Standard | 1/17/2019 0:00 | 3 | 2019 |
61683 | Normal | 11/20/2019 0:00 | 47 | 2019 |
61551 | Normal | 8/3/2019 0:00 | 31 | 2019 |
61482 | Normal | 12/26/2019 0:00 | 52 | 2019 |
61352 | Expedited | 9/13/2019 0:00 | 37 | 2019 |
61678 | Emergency | 6/24/2019 0:00 | 26 | 2019 |
61689 | Expedited | 12/1/2019 0:00 | 49 | 2019 |
61590 | Emergency | 9/15/2019 0:00 | 38 | 2019 |
61360 | Expedited | 10/13/2019 0:00 | 42 | 2019 |
61690 | Approved | 10/16/2019 0:00 | 42 | 2019 |
61698 | Rejected | 12/8/2019 0:00 | 50 | 2019 |
Solved! Go to Solution.
Hi @dcg38524 ,
We can try to use this measure as the value field.
value = COUNTROWS ( FILTER ( ALL ( 'Table' ), [Week of Year] <= MAX ( 'Table'[Week of Year] ) && [Class] IN FILTERS ( 'Table'[Class] ) ) )
If it doesn't meet your requirement, Please show the exact expected result based on the Tables that you have shared.
BTW, pbix as attached.
Best regards,
Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Dong Li, thank you very much your solution worked great the first time - I would not have been able too resolved this issue without your help & this forum.
Best regards,
Don
Hi @dcg38524 ,
We can try to use this measure as the value field.
value = COUNTROWS ( FILTER ( ALL ( 'Table' ), [Week of Year] <= MAX ( 'Table'[Week of Year] ) && [Class] IN FILTERS ( 'Table'[Class] ) ) )
If it doesn't meet your requirement, Please show the exact expected result based on the Tables that you have shared.
BTW, pbix as attached.
Best regards,
Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Dong Li, thank you very much your solution worked great the first time - I would not have been able too resolved this issue without your help & this forum.
Best regards,
Don
See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...
Also, I have written a bunch of week based quick measures:
You also might find Sequential useful:
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 |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |