Show Value only in second level of matrix

[spitfyah]

Hi All,

I have a matrix with the following rows in a hierarchy:

Client

MonthYear

Office

Agent

Recipient ID

I want to make a measure to display the target but only at the MonthYear level so it would show something like this:

Client   Target

Dudes

Gents

Client                  Target

Dudes

   Oct 2021              60

   Nov 2021              40

Gents

   Oct 2021              80

   Nov 2021             21

Client                               Target

Dudes

   Oct 2021

         Chicago Office

         London Office      

   Nov 2021

         Chicago Office

         London Office   

Gents

   Oct 2021

            Beijing Office

             Sydney Office

   Nov 2021                

            Beijing Office

             Sydney Office

Targets are only at a client level but are updated every month. How would I go about achieving this?

I think I have gotten a measure that calculates it, but so far it does it all the way down the hierarchy when really I only want it done on the rows with MonthYear

if(not(isinscope(Dim_Date[YearMonth])),target (variable I created to work out the target), BLANK()) 

if(isinscope(Dim_Date[YearMonth]),target (variable I created to work out the target), BLANK()) 

if(isblank(SELECTEDVALUE(Dim_Date[YearMonth])), BLANK(),target)

How would I get this to work?

[v-yalanwu-msft · Accepted solution]

Hi, @spitfyah ,

I test a simple example. and you could refer it.

Measure = IF(ISINSCOPE('Table'[Client]),IF(ISINSCOPE('Table'[Date]),SUM([Target])))

The final show:

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

you're on the right track with ISINSCOPE() but you may also have to add NOT ISINSCOPE() for the other levels.