Forum Discussion

Mamoun_issa's avatar
Mamoun_issa
Frequent Visitor
6 years ago
Solved

Same patients visit in same day

Hello   I Have patients visits schedule that have the details of the visits and the procedure done in each visits, I neet to diffrentiate visits that have same day visit the data look something lik...
COUNT
DAX Query
quetsion
RANKX
  • Nathaniel_C's avatar
    Nathaniel_C
    6 years ago

    Hi Mamoun_issa ,
    Please try this:

    Same Day =
CALCULATE (
    DISTINCTCOUNT ( myTable[Visit Number] ),
    ALLEXCEPT ( myTable, myTable[Patient Number], myTable[Visit Date] )
)

     

     

Nathaniel_C's avatar
Nathaniel_C
Icon for Community Champion rankCommunity Champion
6 years ago

Hi Mamoun_issa ,
Please try this:

Same Day =
CALCULATE (
    DISTINCTCOUNT ( myTable[Visit Number] ),
    ALLEXCEPT ( myTable, myTable[Patient Number], myTable[Visit Date] )
)