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,
how do i set up a DAX formula to be able to visualize a table as below with these columns;
ID | Column 1: | Column 2: |
1 | Planned | Planned date |
2 | Not planned | |
3 | Actual | Actual date |
BR Patrik
Solved! Go to Solution.
Hi @Anonymous ,
Does your original data look like this?
Then you need to select the ID column, then unpivot other columns.
Then remove the blank value.
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
You need to remove the filter from the [a110] column, so try the following measure.
running total =
CALCULATE (
COUNTA ( FRAS[a110] ),
FILTER (
ALLSELECTED ( FRAS ),
ISONORAFTER ( FRAS[assignment_id], MAX ( FRAS[assignment_id] ), DESC )
)
)
Best Regards,
Winniz
I dont get it to work! Based on the data in table below, i would like to have the cummulative count, but the forumla only adds cumulative sum on the exact same date. What do i wrong?
What I want is to visualize how each row build up over time. (x-axis to show time and y-axis to show cumulative amount of IDs)
Hi @Anonymous ,
You need to remove the filter from the [a110] column, so try the following measure.
running total =
CALCULATE (
COUNTA ( FRAS[a110] ),
FILTER (
ALLSELECTED ( FRAS ),
ISONORAFTER ( FRAS[assignment_id], MAX ( FRAS[assignment_id] ), DESC )
)
)
Best Regards,
Winniz
Perfect, thanks!
Hi @Anonymous ,
Does your original data look like this?
Then you need to select the ID column, then unpivot other columns.
Then remove the blank value.
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Patrik,
I am not 100% sure about your question. I think this bar chart Y-axis is the count of IDs. Hope this is your fact table and it has repeating IDs for each plan.
This is the normal cumulative DAX and you have to use the way you do counting IDs.
[CountIDs] is the measure you need to get the number of IDs.
Now you can use Stack Chart X-axis is dates, values are [Cumulative Count IDs] and legend is Column 1 (plans type).
Regards
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 |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |