Total for a period

[Anonymous]

Hi all,

I have a simple table: Brand, Month, Volume.

I want to add total for a period I select on the slicer. For example, if I select Apr, Aug, Dec, I want to see in 'Total volume' column 2026 (sum for those 3 months) in every row. Is it possible to create a measure to solve this? Thanks

[Anonymous · Accepted solution]

Hi @Anonymous,

Perhaps you can use allselected functions on your formula to expand the current row content to the current table, then they can calculate and show the total level result at each row.

The definitive guide to ALLSELECTED - SQLBI
Regards,

Xiaoxin Sheng

[smpa01]

@Anonymous  can you provide a sample pbix?

[Anonymous]

Yes, sure

https://drive.google.com/file/d/1Lp-_yiIsI6Y1AH8wdpvR5ALu6R3RugSK/view?usp=sharing

[VahidDM]

Hi @Anonymous 

You need to use calendar table (date table) then use the month from that table in your slicer.

Create a Calendar Table = Creating Calendar Table with 3 Steps 

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

[Anonymous]

Thanks,

I've changed it to date format. But how can I calculate measure 'Total volume' with 1186 (total of 2 month) in every row (not total for a month) and calculate % of that total ( for 1st row 456/1186, 2nd 397/1186 etc and total should be 1).