Forum Discussion

StainlessSteel's avatar
StainlessSteel
New Member
2 years ago
Solved

Additive Total Issue

I'm trying to get an additive total, but I am running into the issue below. I've tried using SumX in a few different ways, but I either get the same results or a much larger number.  The context i...
  • StainlessSteel's avatar
    StainlessSteel
    2 years ago

    I was able to get to what I needed.

     

    Since I have a row for each minute, I made a column with the below expression. I could see if I had any anomolies if it counted more than '1' per row, and then I could just use a Sum in my visuals.

     

    Expression for a new Column, and then Sum of the values in a visual

     

    Inside Block =
    CALCULATE(
        COUNTROWS(CALENDAR_MINUTE_BLOCKSCHEDULE),
        FILTER(CALENDAR_MINUTE_BLOCKSCHEDULE,
            CALENDAR_MINUTE_BLOCKSCHEDULE[Resource] = 'NORA Cases'[RESOURCE]  
            && CALENDAR_MINUTE_BLOCKSCHEDULE[Program] = 'NORA Cases'[Derived Program]
            && CALENDAR_MINUTE_BLOCKSCHEDULE[Date_Time] = 'NORA Cases'[Patient Room Minutes]))
StainlessSteel's avatar
StainlessSteel
New Member
2 years ago

I was able to get to what I needed.

 

Since I have a row for each minute, I made a column with the below expression. I could see if I had any anomolies if it counted more than '1' per row, and then I could just use a Sum in my visuals.

 

Expression for a new Column, and then Sum of the values in a visual

 

Inside Block =
CALCULATE(
    COUNTROWS(CALENDAR_MINUTE_BLOCKSCHEDULE),
    FILTER(CALENDAR_MINUTE_BLOCKSCHEDULE,
        CALENDAR_MINUTE_BLOCKSCHEDULE[Resource] = 'NORA Cases'[RESOURCE]  
        && CALENDAR_MINUTE_BLOCKSCHEDULE[Program] = 'NORA Cases'[Derived Program]
        && CALENDAR_MINUTE_BLOCKSCHEDULE[Date_Time] = 'NORA Cases'[Patient Room Minutes]))