cancel
Showing results for
Did you mean:

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.

Anonymous
Not applicable

## Power BI - Accumulate over time, and Percentage

Hi Guys,

I need your assistance here as I am new to Power BI.

November 2021 FIT should be 159 and not 157, and December should be equal to the total of the year as the table should accumulate over time. January 2022 will therefore need to include to total / December 2021 figure in order to continue this journey

I’ve made a small pivot on the data extract, and here you can see, how the FIT% should look on a total basis across requirements:

The above should somehow be presented in a graphical way taking into consideration that total no. of requirements is increasing over time, and that GAP’s can turn into FIT’s and vice versa.

-------

In the table below: Is it possible to add a percentage in the bottom that just calculate the FIT% meaning in September it will be 100%, then it goes down to 67,37 in November and so forth?

Looking at the FIT graph above – September is correct, November is close to it, but I start having hard times – It seems like the GAPS are taking more and more of the majority in relation to the total and therefore this also indicates that no accumulation takes place over time. In February I don’t even understand the blue box, because there are very few requirements falling into this group.

So the red part should overtime be less, less and less taking into consideration that the total number of requirements is growing up to 497 in February starting at 238 in November.

Then (and this is just an idea) for each cell in the above you can then calculate the estimated no. of hours as the sum of requirements, where ((Max dev. Effort – Min dev. Effort) / 3) times 4) gives the value in hrs.

1 ACCEPTED SOLUTION
Community Support

Hi @Anonymous ,

Please try to create a measure like below:

``Measure = CALCULATE(SUM('Table'[ID]),FILTER(ALLEXCEPT('Table','Table'[GIT FIT or GAP]),'Table'[Date]<=MAX('Table'[Date])))``

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Community Support

Hi @Anonymous ,

Please try to create a measure like below:

``Measure = CALCULATE(SUM('Table'[ID]),FILTER(ALLEXCEPT('Table','Table'[GIT FIT or GAP]),'Table'[Date]<=MAX('Table'[Date])))``

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Announcements

#### Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

#### Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

#### Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors