Forum Discussion
IFINSCOPE with Row Level Totals
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
lherbert501 Not sure I fully understand, but maybe this will help: Matrix Measure Total Triple Threat Rock & Roll - Microsoft Fabric Community
2 Replies
- Greg_Deckler
Community Champion
lherbert501 Not sure I fully understand, but maybe this will help: Matrix Measure Total Triple Threat Rock & Roll - Microsoft Fabric Community
- lherbert501
Post Prodigy
Thanks Greg_Deckler