Need Dax formula to show only values in heirarchy in matrix visual

[sudhav]

Hi Team,

I have a visual in the below 

where ever the lower heirarchy(ABC,XYZ) , there i need to get blank value under sumofrevenue(at hilighted area).

I guess isinscope function, but not getting exact dax, plese help me. 

final output i need is below snap shot

[parry2k · Accepted solution]

@sudhav you don't use that measure in the visual, it is to be used in the dynamic format:

IF ( ISINSCOPE ( Table[SubLevel] ), ",,,", "#,0.00" )

[sudhav]

Great, its working as expected. thankyou

[parry2k]

@sudhav you can leverage dynamic format for the measure: in the dynamic format change the format to:

IF ( NOT ISINSCOPE ( Table[Country] ), ",,,", "#,0.00" )

Check the video on dynamic format here From Thousands to Billions: The Power of Dynamic Formatting in Power BI - April 2023 Power BI Update...

👉 Learn Power BI and Fabric - subscribe to our YT channel - @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤️

[sudhav]

Hi thankyou for the reply, the dax which you mentioned is not working for my scenario. 

if i apply that i am getting the below output but which is not the desired one

please look into it and do needful

Thankyou

the required output is below one