Forum Discussion
Displaying Consistent Row-Level Total in Power BI Table
Hello everyone! Glad to be here. I'm having a few questions, hope someone could guide me. In my mind this is not supposed to be hard, but somehow I find it tricky. What I want is to create a me...
HectorMSC this measure will do it:
Total =
CALCULATE ( SUM ( Table[Column] ), ALLSELECTED ( ) )
👉 Learn Power BI and Fabric - subscribe to our YT channel - @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤️
Thank you, I used your formula and added a Filter for Year and it seems to be alright!
GrandTotalSales2021 =
CALCULATE (
SUM ( Hoja1[Ventas Total] ),
FILTER (
ALLSELECTED ( Hoja1 ),
YEAR ( Hoja1[Fecha Venta] ) = 2021
)
)