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 , 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