row wise total

[Anonymous]

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.

[Anonymous]

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

[zenisekd]

@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]

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

[zenisekd]

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