Forum Discussion

Naveen_SV's avatar
Naveen_SV
Helper IV
5 years ago
Solved

Help on Burn Down Chart Design

Hi All,

 

I am creating a brun down chart, Can anyone please help me i have stuck with complition number is not coming properly.

 

Below is my Table,

 

In the same table i was able to write below query.

 

Rank = RANKX('dummy data - Copy','dummy data - Copy'[Warrenty Date],,ASC,Dense)
 and the running table
 
Running_table = CALCULATE(SUM('dummy data - Copy'[Count_of_CAR_Asset]),
ALLEXCEPT('dummy data - Copy','dummy data - Copy'[Country]),'dummy data - Copy','dummy data - Copy'[Rank] <=EARLIER('dummy data - Copy'[Rank]))
Remaining scope as below
 
Remaining scope = CALCULATE(SUM('dummy data - Copy'[Count_of_CAR_Asset]),FILTER('dummy data - Copy','dummy data - Copy'[Country]=EARLIER('dummy data - Copy'[Country])))-'dummy data - Copy'[Running_table] + 'dummy data - Copy'[Count_of_CAR_Asset]
I am seeing the burn down chart numbers wrong ideally it should start from 2213 and next month should lesser then pervious month that means pervious month total - next month total and reduces to zero at the end of the month.
 
Please let me know any soluton to solve this issue.  
 
 

 

 

Need Help
Show and Tell
Tips and Tricks
  • Naveen_SV's avatar
    Naveen_SV
    5 years ago

    v-angzheng-msft  really thanks for replying to my problem.

     

    I was actually looking based on filters when you apply like from your data, if i select Amestradom remaining count should show 911 for the month of jan and it should dedect next month total. 

     

    even if i select asset like "laptop", Mobile based on that group also should be able to see from total - previous month total.

    currently i was able to get the solution by saperating two graph one is based on country and another based on mobile.

2 Replies

  • v-angzheng-msft's avatar
    v-angzheng-msft
    Community Support
    5 years ago

    Hi, Naveen_SV 

     

    Check if the summation method of the value field is summation. The displayed result is incorrect if the summation method is summation because there are duplicate remaining values when the consumption is 0. Change the aggregation method to average, maximum, minimum, etc.
    I created a sample based on the image you provided and in the sample I created two measures as follows:

    _Running =
VAR _running =
    CALCULATE (
        SUM ( 'Table'[Count of CAR Asset] ),
        FILTER ( ALLSELECTED ( 'Table' ), 'Table'[__Rank] <= MAX ( 'Table'[__Rank] ) )
    )
RETURN
    _running

    __Remaining =
VAR _total =
    CALCULATE ( SUM ( 'Table'[Count of CAR Asset] ), ALL ( 'Table' ) )
VAR _result = _total - [_Running]
RETURN
    _result

     Result:

    Please refer to the attachment below for details

     

     

    Hope this helps.

     

    Best Regards,
    Community Support Team _ Zeon Zheng
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Naveen_SV's avatar
    Naveen_SV
    Helper IV
    5 years ago

    v-angzheng-msft  really thanks for replying to my problem.

     

    I was actually looking based on filters when you apply like from your data, if i select Amestradom remaining count should show 911 for the month of jan and it should dedect next month total. 

     

    even if i select asset like "laptop", Mobile based on that group also should be able to see from total - previous month total.

    currently i was able to get the solution by saperating two graph one is based on country and another based on mobile.