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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Boivin12
Regular Visitor

Hide common blank value in matrix

Boivin12_1-1715068581911.png

 

I have this matrix that shows values in common for several hierarchy level.The problem is that some of my orgs don't have the same depth as others. In this case, in my table these are null. I'd like to find a way of hiding a row if there are no other criteria and the number on the right remains the same.

Basically, I want to hide, the rows in green.

1 ACCEPTED SOLUTION
Alex87
Solution Specialist
Solution Specialist

SQLBI explains well the parent child pattern and how to handle blank rows. Have a look here : Parent-child hierarchies – DAX Patterns

 

View solution in original post

2 REPLIES 2
Alex87
Solution Specialist
Solution Specialist

SQLBI explains well the parent child pattern and how to handle blank rows. Have a look here : Parent-child hierarchies – DAX Patterns

 

In the example you gave me, there is a step  :

Sum Amount :=
SUM ( StrategyPlan[Amount] )
 
But in my case, I have my data are in a seperate table. Plus, it's not really a value that I have, it's an ID, so I don't know if I need to sum it. 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

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