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.
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
Solved! Go to Solution.
Hi @AndreySBKN,
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
Hi @AndreySBKN,
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
@AndreySBKN can you provide a sample pbix?
Hi @AndreySBKN
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/
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).
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
43 | |
23 | |
21 | |
15 | |
15 |
User | Count |
---|---|
45 | |
31 | |
30 | |
18 | |
17 |