topic Unique Count : Based on multi condition in DAX Commands and Tips

Unique Count : Based on multi condition

Chandrashekar — Wed, 24 Aug 2022 06:44:48 GMT

Hello,

How to get unique count based on multi condition.

Sample Data: Sample Data 1. Excel file(Having formulas), 2. PBIX file(Help me to get DAX formula).

Regards,

Chandrashekar B

Re: Unique Count : Based on multi condition

tamerj1 — Wed, 24 Aug 2022 07:19:33 GMT

Hi Chandrashekar
Not sure if this is what you're looking for?

Re: Unique Count : Based on multi condition

Anonymous — Wed, 24 Aug 2022 07:29:40 GMT

Hi @Chandrashekar

I cannot reach your expected results. Not sure what you are looking for !

here 2 measures :

Unique Count =

calculate(DISTINCTCOUNT(Sheet1[Column1]),filter(Sheet1,not Sheet1[Column2]IN {"HD"}&&Sheet1[Column3]=1&&Sheet1[Column5]="CH"&&Sheet1[Column4] IN {"First","Second"}))

count = calculate(COUNTROWS(Sheet1),filter(Sheet1,not Sheet1[Column2]IN {"HD"}&&Sheet1[Column3]=1&&Sheet1[Column5]="CH"&&Sheet1[Column4] IN {"First","Second"}))

Re: Unique Count : Based on multi condition

Chandrashekar — Wed, 24 Aug 2022 10:29:36 GMT

Hello,

I will come back to you.

Regards,

Chandrashekar B

Re: Unique Count : Based on multi condition

Chandrashekar — Thu, 25 Aug 2022 05:49:57 GMT

Hello James,

I am looking for unqiue count based on multi condition. For Ex:

Filter Below:

Column1=Exclude :"HD"

Column3=Incude 1

Column4=Include "First" & "Second"

Column5=Include CH.

Below Table after filtering. I need to take unique count from Column2 that will be 10.

Column1	Column2	Column3	Column4	Column5	Hours
IE	CT1	1	Second	CH	10
KESS	CT3	1	Second	CH	10
KESS	CT4	1	Second	CH	10
Mylife	CT5	1	First	CH	10
Mylife	CT7	1	First	CH	10
Mylife	CH1	1	First	CH	10
KESS	CT8	1	Second	CH	10
Mylife	CH2	1	First	CH	11
Mylife	CH2	1	First	CH	12
Mylife	CH2	1	First	CH	12
Mylife	CH3	1	First	CH	12
Mylife	CH3	1	First	CH	12
Mylife	CH3	1	First	CH	12
Mylife	CH4	1	First	CH	12
Mylife	CH4	1	First	CH	12

Re: Unique Count : Based on multi condition

Chandrashekar — Thu, 25 Aug 2022 06:31:47 GMT

Hello James,

It is working fine and thanks for the solution.

Regards,

Chandrashekar B