Unique Count : Based on multi condition

[Chandrashekar]

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

[Anonymous]

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

[Chandrashekar]

Hello James,

It is working fine and thanks for the solution.

Regards,

Chandrashekar B

[Chandrashekar · Accepted solution]

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

[Chandrashekar]

Hello,

I will come back to you.

Regards,

Chandrashekar B

[tamerj1]

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