Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
27 | |
13 | |
11 | |
9 | |
6 |