Maneuvering Total's Row in Table or Matrix in Power BI

In this video you'll learn to manipulate the filter context for the total's row in Table or Matrix visual using HASONEVALUE & INSCOPE functions in Power BI.
===== ONLINE COURSES =====
✔️ Mastering DAX in Power BI -
goodly.co.in/learn-dax-powerbi/
✔️ Power Query Course-
goodly.co.in/learn-power-query/
✔️ Master Excel Step by Step-
goodly.co.in/learn-excel/
✔️ Business Intelligence Dashboards-
goodly.co.in/learn-excel-dash...
===== LINKS 🔗 =====
Blog 📰 - www.goodly.co.in/blog/
Corporate Training 👨‍🏫 - www.goodly.co.in/training/
Need my help on a Project 💻- www.goodly.co.in/consulting/
Download File - goodly.co.in/maneuvering-tota...
===== CONTACT 🌐 =====
Twitter - / chandeep2786
LinkedIn - / chandeepchhabra
Email - [e-mail]
===== CHAPTERS =====
0:00 Intro
0:18 Explanation of the Problem
1:18 Solving with HASONEVALUE Function
3:08 Checking Using Year Filter
4:03 Solving with INSCOPE Function
5:48 Deep Dive into the Query
7:58 My Courses
===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'd find a ton of interesting videos that I have created :) Cheers!
- - - - -
Music By: "After The Fall"
Track Name: "Tears Of Gaia"
Published by: Chill Out Records
- Source: goo.gl/fh3rEJ​
Official After The Fall CZcams Channel Below
czcams.com/channels/GQE.html...
License: Creative Commons Attribution-ShareAlike 4.0 International (CC BY-SA 4.0)
Full license here: creativecommons.org/licenses

[@MarkBrady]

You have such a great teaching method. Love your videos. Thanks for sharing your knowledge

[@Albert-zf8ct]

They way you are laying out the issues really clarify how to deal with every day practical issues. Thanks for good and enlightening dax short videos - Much appreciated!

[@pranaysharma8694]

I recently implemented a dynamic YTD in the column subtotals by controlling them using Hasonevalue function. It worked pretty well, wasn't aware about the isinscope function, its really good information you are sharing. Thanks!.

[@bradj229]

ISINSCOPE is a neat function! Thanks!

[@Nalaka-Wanniarachchi]

Another outstanding video!!
I have experienced that many users are using ISINSCOPE function for rectify incorrect measure totals also.

[@vasilisa6128]

Great video, Chandeep! Thanks!

[@TheMisiekMisiek]

Great solution. Impressive.

[@wayneedmondson1065]

Awesome trick! Thanks and thumbs up!!

[@GoodlyChandeep]

Glad you liked it!

[@chakrabmonoj]

As usual Chandeep, very helpful. I have been struggling with this. If I am working with a table which has dates from a month, MTD sales and MTD-1 sales, for MTD sales the grand total is showing fine for the date range but for M-1, the grand total is for the full month. Is there a way around this?

[@jatindersingh2241]

Love your videos

[@GoodlyChandeep]

Glad you love them !

[@gurusekharreddy6915]

I want to add two additional rows in matrix visual. Like average without week values and with week week off values. Only end

[@ravireddy270]

I'm started to learn through your videos

[@GoodlyChandeep]

Glad they are helpful!

[@neelbanerjee7875]

Really awesome brother... Could you please make a video on SUMMARIZE table function in details along with some real time use cases? Thanks in advance..

[@chengwang411]

great ~

[@GoodlyChandeep]

Thanks!

[@powerbinareal]

Insane!!!!!!

[@GoodlyChandeep]

Thank you!

[@yathishkumar9770]

Hi,
Can we sort the Matrix visaul by row totals.

[@anshno1]

Hey chandeep, amazing content!
Although, sometimes when we have multiple columns in our matrix, the subtotal and grandtotals values are usually wrong, suppose I have country and year column, and I am showing sales, when I turn my subtotals on, for country subtotal, it will give me subtotal for all the years, and year subtotal will give me totals for all years per country, but I do not have any option to show totals for all countries per year! How do we work around this problem?

[@kiran521]

Hi Chandeep, Can u please make video on difference between pro, premium and ppu license.

[@kuldeepsalve4606]

I have used matrix visualisation in my project, there I got Totals and Subtotals for different heirarchies .But I also want to create custom subtotals for different rows which are under different heirarchies. Could u please help me out that how to get it..

[@pankajkumarit04]

Gr8 Videos. Is there a way to get the row total from Extreme "Right" to Extreme Left. Have been looking for this solution fiercely . Please help.

[@basireddy1387]

Hi
I need your video on Migrating / Converting SSRS reports to power bi reports.
i found a lot of stuff from you i need to see more detail in real time waiting to see eagerly your response