Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

How to create a working burndown chart that uses total count for all dates

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

 

BDaly_0-1623184541734.png

However when I filter it to a specific location it begins to break down. 

BDaly_1-1623184654716.png

 

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,

1 REPLY 1
Anonymous
Not applicable

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.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.