Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Team,
Refer Document " We Add Column Wise Total Value.docx " and Advise how can add Column for Matrix with Custom
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
I am sorry, but what's your point!
Did your issue solved or not yet?
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
team any update
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.
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
@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.⚡
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
hello,
am not clear how to use Inscope for Total in Matrix table.
User | Count |
---|---|
92 | |
85 | |
76 | |
66 | |
62 |
User | Count |
---|---|
110 | |
96 | |
95 | |
64 | |
57 |