Add Column Total With Switch True

[unais]

Team,

Refer Document  " We Add Column Wise Total Value.docx "  and Advise how can add Column for Matrix with Custom

[unais]

@aj1973 

Exactly I had created individual Group measures.. , Here I had enabled Drill though option, From Gl Group to Gl Names ( Multiple GL Names to a GL Group ) . 

Ex: Ggroup1

           GL Name1

           GL Name2

           GL Name3

    Ggroup2

           GL Name6

           GL Name7

           GL Name8

Total = Ggroup1+Ggroup2

while showing Total Drip option will show all GL Names

[aj1973]

@unais 

I am sorry, but what's your point!

Did your issue solved or not yet?

[unais]

team  any update

[aj1973]

Hi @unais 

Your measure is not clear what do you want to acheive!!

Your Matrix is heavy loaded with GL Accounts and Groups, a risk of performance might accure.

My recommendation : before you go any further is that you create Measures for each group and then sum up your calculations, here is an example I made

I created a measure for each line and then put them into a Matrix.

I know it is a long way but secure and easy to catch mistakes and at the end the Matrix's performance is better.

[parry2k]

@unais check ISINSCOPE function. Here is an amazing blog post talks about this.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to 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.⚡

[unais]

hello,

am not clear how to use Inscope for Total in Matrix table.