topic List of all clients in client groups that contain at least 1 client that has had certain help in DAX Commands and Tips

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

jelledaems — Mon, 06 Sep 2021 08:22:40 GMT

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

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

amitchandak — Mon, 06 Sep 2021 10:07:27 GMT

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

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

jelledaems — Mon, 06 Sep 2021 11:06:53 GMT

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