Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
sudhav
Helper V
Helper V

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

Hi Team,

I have a visual in the below 

sudhav_0-1692210703169.png

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

 

sudhav_1-1692210876357.png

1 ACCEPTED SOLUTION
parry2k
Super User
Super User

@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" )


Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @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! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

View solution in original post

4 REPLIES 4
parry2k
Super User
Super User

@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" )


Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @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! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Great, its working as expected. thankyou
parry2k
Super User
Super User

@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! ❤️



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @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! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

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

 

sudhav_1-1692250031672.png

please look into it and do needful

Thankyou

 

 

 

the required output is below one

sudhav_0-1692249998009.png

 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors