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 Community,
this is my first post and I have already browsed the web for solutions, but somehow, I am stuck. 😕
So I am trying to show cumulated training completions per date (run-up) in a graph - see below:
When I use the filters on the left, the charts look exactly as I planned to.
But if I remove the filter and show the "overall cumulations", then the graphs are screwed. 😞
I am using the following formula to calculate the cumulative completions.
What's wrong? I also found a way to make the overall look good, but then the filter per region does not work:
Thanks for your response! To be honest, I do not know whether we need to define and ELSE rule. I found nothing about that in my research. I think here, it's more used as a "WHILE"...!?
VAR Result =
IF (
FirstVisibleDate <= LastDateWithSales,
CALCULATE (
COUNTA([User ID]),
'TKLMSREPORT - 2021-08-02T144129 529'[Completion Date] <= LastVisibleDate
)
)
What should happen if the condition is not met?
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 |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |