Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hello I have these 2 simple table
Tabella (2)
Calendario
I would like to have report a table with one column that show the sum of all the value of the group "a" on all the row but only for the selected period
So If I filter only the year 2001-2003 I want all the row with the value 100. If I filter all the year I want all the row with the value 500 (100+400) like below
I have tryed some formulas like the below but noone of them give me the expected result
Solved! Go to Solution.
@Guitarseb
I am not sure what results you need at grand total level, check this measure please:
sum a value =
CALCULATE(
SUM(Tabella2[valore]),
Tabella2[Gruppo] = "a",
ALLSELECTED(Tabella2)
)
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Hello, i am trying to do the same thing here, but i can't fugure out how.. did you found a working solution eventually?
@Guitarseb
I am not sure what results you need at grand total level, check this measure please:
sum a value =
CALCULATE(
SUM(Tabella2[valore]),
Tabella2[Gruppo] = "a",
ALLSELECTED(Tabella2)
)
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Hi Funny, i found the problem. I was writing the formula in a new column instead of a new measure. So now your formula is working.
Thanks
No i'm sorry but I still get the same result. When I filter with the year the total is not filtered. I would like to filter all the data like the Subtotal at the end of the table and then filter only the group="a". This is the result I get with your formula: all 500 that is the sum of the value of the 2001 and 2006 (100+400)
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
21 | |
15 | |
15 | |
11 | |
7 |
User | Count |
---|---|
25 | |
24 | |
12 | |
12 | |
11 |