Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Measure

i have my data as follows

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


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. 

Need Help
  • Fowmy's avatar
    Fowmy
    5 years ago

    Anonymous 

    You can use this measure:

    Unique Case Numbers = 

CALCULATE(
    DISTINCTCOUNT(Table[Case Number]),
    Table[Procedure code] = "SN21" 
)
  • Fowmy's avatar
    Fowmy
    5 years ago

    Anonymous 

    Try this:

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

3 Replies

  • Fowmy's avatar
    Fowmy
    Super User
    5 years ago

    Anonymous 

    You can use this measure:

    Unique Case Numbers = 

CALCULATE(
    DISTINCTCOUNT(Table[Case Number]),
    Table[Procedure code] = "SN21" 
)
    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

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

      • Fowmy's avatar
        Fowmy
        Super User
        5 years ago

        Anonymous 

        Try this:

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