Measure

[Anonymous]

i have my data as follows

Case Number	Procedure code
1505	SN21
1505	SN21
1505	SN23
1508	SN21
1508	MR28
1509	SN21
1510	MR28
1511	SN23
1512	SN23
1509	SN21
1513	SN21
1513	SN21

I am trying to create a measure that counts unique "CaseNumbers" that are carrying "SN21" procedure Code.

(or)

Count of CaseNumbers that has SN21 procedure code repeated twice. 

[Fowmy · Accepted solution]

@Anonymous 

You can use this measure:

Unique Case Numbers = 

CALCULATE(
    DISTINCTCOUNT(Table[Case Number]),
    Table[Procedure code] = "SN21" 
)

[Fowmy · Accepted solution]

@Anonymous 

You can use this measure:

Unique Case Numbers = 

CALCULATE(
    DISTINCTCOUNT(Table[Case Number]),
    Table[Procedure code] = "SN21" 
)

[Anonymous]

Is there any way to use this expression to subract the SN21 procedure total count - SN21 procedure distinct ocunt!!

[Fowmy · Accepted solution]

@Anonymous 

Try this:

Unique Case Numbers = 
CALCULATE(
    COUNT(Table2[Case Number]),
    Table2[Procedure code] = "SN21" 
)
-
CALCULATE(
    DISTINCTCOUNT(Table2[Case Number]),
    Table2[Procedure code] = "SN21" 
)