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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

Reply
witbi
Helper I
Helper I

DAX calculate table values that is not blank

I have the following hierarchy table and am stuck to generate a sub table that can filter out the blank row.

Any assistance would be most appreciated!

DepartmentManager

Staff

Human Resources  
Human ResourcesA 
Human ResourcesAG
Human ResourcesB 
Human ResourcesBH
Human ResourcesBI
Engineering  
EngineeringC 
EngineeringCJ
EngineeringCK
EngineeringCL
EngineeringD 
EngineeringDM
EngineeringE 
EngineeringEN
EngineeringEO
Accounting & Finance  
Accounting & FinanceF 
Accounting & FinanceFP
Accounting & FinanceFQ

 

witbi_0-1624874799856.png

 


1 ACCEPTED SOLUTION
Jihwan_Kim
Super User
Super User

Picture1.png


If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

View solution in original post

1 REPLY 1
Jihwan_Kim
Super User
Super User

Picture1.png


If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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