Hide Blank at the 2nd level of hierarchy in matrix

[tracytran91]

Hi friends, 

I would like to have a DAX measure which helps me to hide the blanks of coverage measure at the second level of hierarchy,  but NOTE HIDE blank of coverage measure at 1st level hierarchy AND DOES NOT AFFECT the GRAND TOTAL in the end of matrix.  

@amitchandak He helped me out to hide the blank at 2nd level. However, It needs to work on how not to hide the blank at the 1st level. Here is the measure: 

GrandTotal = 
VAR NewTotal = if(isblank([Coverage]), blank(), [Total])
RETURN 
if(isinscope(Product[Code]), NewTotal, [Total])

Could anyone help me regarding this issue?

I highly appreciate your help!!

Thank you in advance. 

[tracytran91]

@amitchandak Thank you for your help. 

Your solution works perfectly for the 2nd level of hierarchy. However, my data - at the 1st level of hierarchy has blank, therefore the number of total measure is incorrect. 

Could you please help me solve it out? 

[amitchandak · Accepted solution]

@tracytran91 , You need to use two measures one for total and one for sub total

Current is [Total]

New Total = if(isblank([covergae]), blank(), [Total])

Final Total = if(isinscope(Table[Market level 2]),  [New Total], [Total])

Use the correct second level column name 

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