topic How to filter N conditions and count how many customers they have? in DAX Commands and Tips

How to filter N conditions and count how many customers they have?

Eder_Govoni — Thu, 06 Jul 2023 23:34:44 GMT

Hello.

Please help me with a question, I've been looking for this solution for days.

I have the table:

I need to filter the Blue, Green and Pink services.

Returning only the number of customers who have these values, in PWBI the card is counting all customers, for example who has the Blue services, but the idea is to filter only who has the 3 services together.

I tried with calculate, with filter, keep filters, everything, everything selected, but without success.

This is just one case, but I have a project, which I want to filter N possibilities, for example, Blue with Pink, or Orange with Indigo, in short, I need a formula that is adaptable.

Re: How to filter N conditions and count how many customers they have?

Nathaniel_C — Fri, 07 Jul 2023 01:05:31 GMT

Hi Eder_Govoni ,
Would you copy and paste this table rather than add a picture. We might be able to give you a solution.

Thank you,
If you would share your pbix, or dummy up some values in Excel both for current and expected data. Please copy and paste them into your post, rather than doing a picture, we may be able to help you.

Please read this post to get your question answered more quickly:

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Nathaniel

Re: How to filter N conditions and count how many customers they have?

Eder_Govoni — Fri, 07 Jul 2023 05:36:49 GMT

sure, sorry for the mistake.

Here is my pbi.

https://drive.google.com/file/d/1nyQED4e2HHvgCu_1rAMt2RFAL39kcry6/view?usp=sharing

Re: How to filter N conditions and count how many customers they have?

Anonymous — Mon, 10 Jul 2023 03:08:16 GMT

Hi Eder_Govoni ,

Please try this measure:

test = VAR __SelectedServices = ALLSELECTED('Case Client'[Service]) VAR __ServiceCount = COUNTROWS(__SelectedServices) RETURN CALCULATE ( DISTINCTCOUNT ( 'Case Client'[Client] ), FILTER ( ADDCOLUMNS ( VALUES ( 'Case Client'[Client] ), "ServiceCount", CALCULATE ( COUNTROWS ( 'Case Client' ), 'Case Client'[Service] IN __SelectedServices ) ), [ServiceCount] = __ServiceCount ) ) + 0

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data in the Power BI Forum

Re: How to filter N conditions and count how many customers they have?

Eder_Govoni — Mon, 10 Jul 2023 22:44:04 GMT

My friend, thank you very much.

I could never think this way, it helped me a lot!