Apply a measure to only one field in a matrix?

[airwolf39]

Hi all, 

I need a measure where "Consolidate" and "defer" only shows up at the customer name level and not on the sale order drill down as it is doing currently (highlighted below). I would like the "defers" in the below example to be blank.

 

Any help would be appreciated.

Thanks,

Brian

[amitchandak]

@airwolf39 , isinscope can help

if(isinscope (Table[Customer_name]), [Model recommendation], blank())

https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/

[airwolf39]

I have never used isinscope before, but it appears to be working in a way that i would not expect. For some reason the formula shows that my sales order #s are inscope of the customer name and so the forumla doesnt work:

[mahoneypat · Accepted solution]

Try using ISINSCOPE with the Sales Order No column and put your measure in the false condition (blank() if true).

Pat