Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

row wise total

here the total column is column subtotal a default calculation. how can i get this through formula. as later i want this column to calculate avg of that particular period.

Need Help

4 Replies

  • zenisekd's avatar
    zenisekd
    Super User
    2 years ago

    Anonymous  you can directly in the visual decide, what sort of aggregation operation you want to happen:

    As far as I am aware, there is no way of getting a different operation, then predefined, natively from the Microsoft visual.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      it is not showing in my power bi...which version it is.....moreover can we develop a formula for this

      • zenisekd's avatar
        zenisekd
        Super User
        2 years ago

        This view is still in Preview. just right-click on the filed in the visualization panel and select the type of aggregation you need. 

         

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous ,

     

    Please try:

    Measure = AVERAGEX(VALUES('Table'[WeekDayName]),[the measure of value])

    Need to replace field names and measure names according to the actual model.

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group