topic Re: Total for a period in DAX Commands and Tips

Total for a period

Anonymous — Sun, 21 Nov 2021 22:14:10 GMT

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

Re: Total for a period

VahidDM — Sun, 21 Nov 2021 23:06:36 GMT

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/

Re: Total for a period

Anonymous — Mon, 22 Nov 2021 15:35:03 GMT

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).

Re: Total for a period

smpa01 — Mon, 22 Nov 2021 17:03:59 GMT

Anonymous can you provide a sample pbix?

Re: Total for a period

Anonymous — Mon, 22 Nov 2021 18:52:20 GMT

Yes, sure

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

Re: Total for a period

Anonymous — Thu, 25 Nov 2021 07:18:01 GMT

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