Showing Just the Subtotals for a specific column in the matrix visual

[saumitra]

Hello All,

I have created a matrix which looks like below:

Now for the 'Net Qty' Column, I need to only show the subtotal and not the MRP or Discounted Values. is there any way I can do this??

Please help.

Regards,

Saumitra Upadhyay

[amitchandak]

@saumitra , see if this can help

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

[saumitra]

@amitchandak

The article you sent is for solving hterarchies when a different calulation is needed on a different level,

This is a silple sales data in which I dont need the row values but just the row subtotal to be shown in the 'Net Qty' column.

I'm afraid your article doesn't help.

Regards,

Saumitra Upadhyay

[v-xuding-msft · Accepted solution]

Hi @saumitra ,

Please try to use ISINSCOPE function to have a try.

Measure 3 = IF(ISINSCOPE('Table'[Product]),BLANK(),[Total Sales])