Forum Discussion

lherbert501's avatar
lherbert501
Icon for Post Prodigy rankPost Prodigy
2 years ago
Solved

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