Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Proper Filtering Context for Distinctcounts

Hello,   I have a table with a handful of columns that offer information about the transactional history of a case. The Case Number, the Time of Entry into Queue and AssignTime are the primary colu...
Need Help
Tips and Tricks
  • OwenAuger's avatar
    OwenAuger
    8 years ago

    Anonymous

     

    Here is a simple measure that should do what you want:

    Cases Never Assigned =
COUNTROWS (
    FILTER (
        VALUES ( YourTable[Case Number] ),
        ISBLANK ( CALCULATE ( MAX ( YourTable[AssignTime] ) ) )
    )
)

    The measure counts the number of Case Numbers where the maximum AssignTime is blank, indicating that there is no AssignTime.

    You could possibly do something with SELECTEDVALUE but I think this measure is good enough.

     

    Regards,

    Owen

OwenAuger's avatar
OwenAuger
Super User
8 years ago

Anonymous

 

Here is a simple measure that should do what you want:

Cases Never Assigned =
COUNTROWS (
    FILTER (
        VALUES ( YourTable[Case Number] ),
        ISBLANK ( CALCULATE ( MAX ( YourTable[AssignTime] ) ) )
    )
)

The measure counts the number of Case Numbers where the maximum AssignTime is blank, indicating that there is no AssignTime.

You could possibly do something with SELECTEDVALUE but I think this measure is good enough.

 

Regards,

Owen

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago
    Thanks Owen - this works great. Appreciate the help.