Forum Discussion

CarlaTP's avatar
CarlaTP
Frequent Visitor
4 years ago
Solved

FILTER inside CONCATENATEX

I'm new to Power Bi/DAX and having trouble getting my head around connecting some measures together.   I'm displaying which doctors operate at which hospitals today, according to a 4 week roster. A...
  • amitchandak's avatar
    4 years ago

    CarlaTP , something like this

     

    concatenateX(
    ADDCOLUMNS( Summarize (calculatetable(Episodes, KEEPFILTERS (
    TREATAS (
    {
    1
    },
    CalendarRequested[Is Same As Today]
    )
    ),
    FILTER (
    CalendarRequested,
    CalendarRequested[Date]
    IN DATESINPERIOD (
    CalendarRequested[Date],
    TODAY (),
    -85,
    DAY
    )
    )) ,
    Episodes[Doctor],
    Episodes[Location]),

    "Seen In Three", DISTINCTCOUNT(Episodes[Requested] )
    ) ,[Doctor])