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 August 31st. Request your voucher.

Reply
edrft_99
Regular Visitor

sum of blank rows across multiple values

I feel silly that I can not get this one. But I am trying to make a measure that will give a sum for how many blank rows that fall under the below Hybrid row. The customer and owner are simple, but the Hybrid ones span both the owner and customer columns and for the life of me I cant get a measure to work correctly. 

 

edrft_99_0-1608767554593.png

 

Thank you for any help. 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@edrft_99 , to me these seem like

 

Dual Responsibility = calculate(count(Table[Responsibility]), filter(Table, Table[Responsibility] = "Dual"))
Owner Implementation Missing = calculate(count(Table[Responsibility]), filter(Table, Table[Responsibility] = "Dual" && isblank(Table[Owner Implementation])))
Owner Implementation Missing = calculate(count(Table[Responsibility]), filter(Table, Table[Responsibility] = "Dual" && isblank(Table[Owner Test])))

Customer Implementation Missing = calculate(count(Table[Responsibility]), filter(Table, Table[Responsibility] = "Dual" && isblank(Table[Customer Implementation])))
Customer Implementation Missing = calculate(count(Table[Responsibility]), filter(Table, Table[Responsibility] = "Dual" && isblank(Table[Customer Test])))

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

6 REPLIES 6
amitchandak
Super User
Super User

@edrft_99 , to me these seem like

 

Dual Responsibility = calculate(count(Table[Responsibility]), filter(Table, Table[Responsibility] = "Dual"))
Owner Implementation Missing = calculate(count(Table[Responsibility]), filter(Table, Table[Responsibility] = "Dual" && isblank(Table[Owner Implementation])))
Owner Implementation Missing = calculate(count(Table[Responsibility]), filter(Table, Table[Responsibility] = "Dual" && isblank(Table[Owner Test])))

Customer Implementation Missing = calculate(count(Table[Responsibility]), filter(Table, Table[Responsibility] = "Dual" && isblank(Table[Customer Implementation])))
Customer Implementation Missing = calculate(count(Table[Responsibility]), filter(Table, Table[Responsibility] = "Dual" && isblank(Table[Customer Test])))

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
amitchandak
Super User
Super User

@edrft_99 , You can have measures like these

 

Owner Responsibility = calculate(count(Table[Responsibility]), filter(Table, Table[Responsibility] = "Owner"))

 

Owner Implementation Missing = calculate(count(Table[Responsibility]), filter(Table, Table[Responsibility] = "Owner" && isblank(Table[Owner Implementation])))

 

Owner Implementation Missing = calculate(count(Table[Responsibility]), filter(Table, Table[Responsibility] = "Owner" && isblank(Table[Owner Test])))


Customer Responsibility = calculate(count(Table[Responsibility]), filter(Table, Table[Responsibility] = "Customer"))

 

Customer Implementation Missing = calculate(count(Table[Responsibility]), filter(Table, Table[Responsibility] = "Customer" && isblank(Table[Customer Implementation])))

 

Customer Implementation Missing = calculate(count(Table[Responsibility]), filter(Table, Table[Responsibility] = "Customer" && isblank(Table[Customer Test])))

 

 

Others you can create with help of these

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Thank you for that. 

 

I was able to get those measures fairly eaisly, the one I was having issue with was the Dual Responsobility. I know the best way is a filter, I am just lost in the sauce on that one. 

 

 

edrft_99
Regular Visitor

edrft_99_0-1608780869746.png

 

Thank you for the response. Attached is a sample of the data and the expected output. 

 

 

amitchandak
Super User
Super User

@edrft_99 ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Appreciate your Kudos.

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
lbendlin
Super User
Super User

Please provide sample data in usable format and show the expected outcome.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.