Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

DAX Distinct Count with Filter

I'm comparing 2 columns; [Ticket Number] and [Scan datetime] in the same table. I need to find the total number of unique tickets with a scan. I came up with the following formula but not sure if it...
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago
    Anonymous - I do not see anything wrong with that calculation. It is probably not how I would have structured it but because I try to avoid using CALCULATE but there is nothing wrong with it if your intention is to get a distinct count of only the TICKET's that have a SCAN_DATETIME.
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago
Anonymous - I do not see anything wrong with that calculation. It is probably not how I would have structured it but because I try to avoid using CALCULATE but there is nothing wrong with it if your intention is to get a distinct count of only the TICKET's that have a SCAN_DATETIME.
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Greg_Deckler thank you for confirming. Appreciate your help.