Customize the 'Total' Formula for a visual

[DevadathanK]

Hi community!

<Message deleted>

Thanks for any help!

[DevadathanK · Accepted solution]

It did indeed turn out that i was over complicating things. 

By skipping the creation of Table 2 completely and by using the same Dataset of Table1 to make the 2nd visual, i am able to get this result. 

I gave the 'House' as the Matric Row and the Subjects as the Matrix Values and selected the average value. 

Thanks all for the help! Your techniques will surely be useful to me in the future.

[parry2k]

@DevadathanK seems like you are overcomplicating your calculation, anyhow, you can use HASONEFILTER function to check if you are on total line then create a different calculation

Measure = 
IF ( HASONEFILTER( Table[Room] ), <<your average calculation>>,
DIVIDE( SUM ( Table[MathCol] ), COUNTROWS( VALUES ( Table[Room] ) ) )
)

tweak the above measure as per your need.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[amitchandak]

@DevadathanK , you can try isfiltered or isinscope

if(isfiltered(Table[House]),sum('Table1'[Mathematics]),[Mathematics])

https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/

https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/