Forum Discussion

DRJ1994's avatar
DRJ1994
Helper I
2 years ago

Division issue and circular dependancy error

Hi all,   I have run into a series of errors on a dashboard I am trying to produce.   I am trying to work out the occupancy rate of a small block of flats. I have the below visual:   The ...
Need Help
Tips and Tricks
amitchandak's avatar
amitchandak
Super User
2 years ago

DRJ1994, Seem like you are using one measure and one column.

 

Create a new measure using both measures

 

Aggregate the column in numerator

DRJ1994's avatar
DRJ1994
Helper I
2 years ago

Thanks, sorry could you explain a bit more what you mean please? 

  • amitchandak's avatar
    amitchandak
    Super User
    2 years ago

    DRJ1994 , To me seems like Days in service is column

     

    So new measures will be

     

    Occupany Rate = Divide(Sum(Customer Tracker [Daystaservice]), [Possible Bed Days],0)

    • DRJ1994's avatar
      DRJ1994
      Helper I
      2 years ago

      Thanks, I have tried the query as follows: 

      Occupancy Rate = DIVIDE(SUM('Customer Tracker'[DaysInService],([Possible Bed Days]),0))
      I am now getting the error "Too Many arguments were passed to the sum function, the maximum argument is 1"
      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi DRJ1994 ,

        Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

        How to Get Your Question Answered Quickly  

        Regards,

        Xiaoxin Sheng