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

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
8 years ago

Hi Anonymous,

In summary, there are 4 distinct cases and I want to show that 2 of the 4 were never assigned. I need to keep the rows that do not have an Assigntime indication as they include other information that is included in different measures within the report. Any help is appreciated.

 

 

I would appreciated if you could share your expected output, so that we can help further investigate on it?

 

Best Regards,

Cherry