My first dashboard

DAX DAX Calculations
1

Hi all, I am trying to set up a bed occupancy dashboard by days, facility, and type of resident. I loaded in Power BI the budget for the year. I have to calculate the % occupancy and when I am calculated the available bed days by type -permanent and respite resident, I get the same amount of days …The formula I used as per below:
Kindly let me know, if the formula looks ok.I can send the data sample if need it.
Bed allocation Permanent =

CALCULATE([Available beds Now],

‘Actual beds available by facili’[Bed Allocation by Facility]=“Permanent”)

2

Hi @Victoria ctoria,

You need to use FILTER: CALCULATE([Available beds Now], FILTER(

‘Actual beds available by facili’[Bed Allocation by Facility]=“Permanent”))

have fun, Jose Milhazes

3

Hi Jose, Thank you, for some reason, it didn’t work but I found a variable formula that did the job.

Regards,

1 Like