Average in a table visualisation instead of Total, Possible?

[The8]

Hi,

It's an simple question. IS that possible to have a average values of all rows in table as shown in image of table visualisation instead of total values of rows?

If yes, let me know with sample data of your choiceand how?

Thanks in advance.

@PravalikaT 

[The8]

@devesh_gupta  I am intrested with your Solution 2, the video which shows me a table with Avg. at total by creating a measure. 

In this measure in video we have formula where we use column names(Brand) and as well measure (net). I have taken inputs from video and generated a measure where we use column names of my table.

For example 

Table name: Column Total by Avg.

Columns 
Level, Value 1 , Value 2

Row value 1 Avg. =

IF (

    ISINSCOPE('Column Total by Avg'[Level]),

    SUM('Column Total by Avg'[Value 1]),

    AVERAGEX(VALUES('Column Total by Avg'[Level]), CALCULATE(SUM('Column Total by Avg'[Value 1])))

)
Thanks @devesh_gupta 

[devesh_gupta · Accepted solution]

@The8 Yes, it is possible to show the average values of all rows in a table instead of the total values of rows.

Solution1: In Power BI, you can right-click on your value fields and choose the aggregate mode ‘average’.

Solution2: If you don't want to see average at the row level and only want to see average at the total level then you can achieve this by using ISINSCOPE. You can follow this tutorial for the same, it'll defiitely help you: https://youtu.be/smhIPw3OkKA?feature=shared

If you find this insightful, please provide a Kudo and accept this as a solution.