cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper I

## How to get a moving total and percent of total based on date?

Right now I have a column with the combined total of another column so I can use that column to get a percentage value. Right now I get results like this:

Using this method, whenever I move the date slider, the hours change, but the percentages will no longer add up to 100% because those numbers are dividing over the static total column (which has the 903,598).

I was hoping for a better way to get those percentages, one that would include being able to use the date slicer to get a moving total, but still see the results of the percentage be out of 100%. So, if I moved the slicer to show only this last year, the total would be something like 130,000 and each month would divide their amount by 130,000 to get the percentage of that number for that date range.

1 ACCEPTED SOLUTION
Super User

@scorbin , if you want to consider filter

Then try % of total like

divide(Sum(Table[Hour]) , Calculate(Sum(Table[Hour]), allselected()) )

or Try like - filter of date will be removed

divide(Sum(Table[Hour]) , Calculate(Sum(Table[Hour]), all()) )

2 REPLIES 2
Super User

@scorbin , if you want to consider filter

Then try % of total like

divide(Sum(Table[Hour]) , Calculate(Sum(Table[Hour]), allselected()) )

or Try like - filter of date will be removed

divide(Sum(Table[Hour]) , Calculate(Sum(Table[Hour]), all()) )

Helper I

That first expression worked! Thanks. Would you have a second to explain why? Does the ALLSELECTED part tell the output to look at filter context?

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

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

#### Fabric Community Update - August 2024

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

Top Solution Authors
Top Kudoed Authors