Forum Discussion

HectorMSC's avatar
HectorMSC
Frequent Visitor
3 years ago

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...
Need Help
parry2k's avatar
parry2k
Super User
3 years ago

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! ❤️

 

 

  • HectorMSC's avatar
    HectorMSC
    Frequent Visitor
    3 years ago

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