Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
Check it out now!Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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)