Reply
jelledaems
Frequent Visitor

List of all clients in client groups that contain at least 1 client that has had certain help

Dear community

 

I'm relatively new to DAX, so I'm still learning. I am trying to figure something out which is probably not difficult for you, but I've been searching and I have not found a solution yet.

 

A client belongs to a client group. And a client gets a certain type of help from the government. There are different types of help like: money, meals, house... 

 

My question: I would like to have a list of all clients that belong to a client group that contains at least 1 client that has gotten the type of help "Meals".

 

So if there is a client group that contains 4 persons, of which 1 person has gotten the type of help "Meals" and the other have gotten the type of help "Money", then I would still like to see all clients as at least 1 client in that client group has had "Meals".  

 

Thank you in advance

 

Kind regards

Jelle

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@jelledaems , Try measure like

 

Table[Sales new used] = "New"))

measure =
var _cnt = calculate(countrows(filter(Table, Table[Help type] = ""Meal)), allexcept(Table, Table[client group]))
return
calculate(count(Table[client]), filter(Table, not(isblank(_cnt))))

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

2 REPLIES 2
jelledaems
Frequent Visitor

Thank you, @amitchandak This seems to do the trick. I'll analyze your solution now, so that I will also learn from it!

amitchandak
Super User
Super User

@jelledaems , Try measure like

 

Table[Sales new used] = "New"))

measure =
var _cnt = calculate(countrows(filter(Table, Table[Help type] = ""Meal)), allexcept(Table, Table[client group]))
return
calculate(count(Table[client]), filter(Table, not(isblank(_cnt))))

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

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

March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)