IFINSCOPE with Row Level Totals

[lherbert501]

Hi ,

I have a IFINSCOPE measure which performs how I want it to and outputs below.

Total = IF ( ISINSCOPE ( Test[HeadCust]) && NOT ( ISINSCOPE ( test[CustAccount] )   ),   [calc1] ,  [calc2] )

My problem is that I want the Report Total below thats for a specific row level total to also use [calc1] above. Is there a way I can reference the total for that specific row level in my IFINSCOPE?  

Expected outcome below would be that the Report Total says 7k then -3k also.

Thanks

Liam

[Greg_Deckler · Accepted solution]

@lherbert501 Not sure I fully understand, but maybe this will help: Matrix Measure Total Triple Threat Rock & Roll - Microsoft Fabric Community

[lherbert501]

Thanks @Greg_Deckler