Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I am trying to build a burndown chart that tracks planned vs actuals on getting devices enrolled in intune. My data source is an excel file on a sharepoint site. I am able to get the total count of devices to make the burndown work when the location selected is all
However when I filter it to a specific location it begins to break down.
I created a calculated table using SUMMARIZE which has two columns. Location, and total count of devices. When I put it across a date axis though it just shows the total count for that day and I want the total count of that location. I then subtract a running total of the number of devices that have been registered to be left with how many are still needing to be registered.
This might end up being an easy fix, but its stumping me pretty bad.... Any help is appreciated.
Thank you for your time,
First, here's a word of caution about SUMMARIZE:
https://www.sqlbi.com/articles/all-the-secrets-of-summarize/
Second, without concrete information about your model and formulas used, the info above is not enough to give guidance.
User | Count |
---|---|
57 | |
22 | |
18 | |
16 | |
11 |
User | Count |
---|---|
85 | |
54 | |
39 | |
21 | |
18 |