Forum Discussion

jdb0912's avatar
jdb0912
New Member
3 years ago
Solved

Calculated column not referencing original entry properly

Hi everyone,   I wasn't sure how to really title the exact issue I was facing, so I explained it as best as I could below.   I'm trying to calculate bed days, then associate the insurance informa...
Need Help
  • mlsx4's avatar
    mlsx4
    3 years ago

    Hi jdb0912 

     

    First of all you should establish two inactive relationship: between Admit Date and Calendar and Discharge Date and Calendar.

     

    Then, you can calculate active beds (with this formula you also check if discharge date is empty in case the patient is still on it:

     

     

    Active beds= 
    CALCULATE(DISTINCTCOUNT('Table'[Visit ID]),
    FILTER('Table','Table'[Admit Date]<=MAX('Calendar'[Fechas]) && OR('Table'[Discharge Date] >=MAX('Calendar'[Fechas]),ISBLANK('Table'[Discharge Date]))))

     

     

     

    And now, you can display it in a matrix:

     

     

  • mlsx4's avatar
    mlsx4
    3 years ago

    Then, add a new measure:

     

    Sum of bed days= SUMX(CalendarTable,[Active beds])
mlsx4's avatar
mlsx4
Memorable Member
3 years ago

Hi jdb0912 

 

And what do you need to show? A sum, an average?

jdb0912's avatar
jdb0912
New Member
3 years ago

I'd need a sum of the bed days.

  • mlsx4's avatar
    mlsx4
    Memorable Member
    3 years ago

    Then, add a new measure:

     

    Sum of bed days= SUMX(CalendarTable,[Active beds])
    • jdb0912's avatar
      jdb0912
      New Member
      3 years ago

      Oh I see. I'm supposed to create the measure in the Calendar table and not the Visits table. I think it's working as intended now. Thanks for the help.