Filtering and DAX question

[iioannou]

Hello,

I have a very simple question and I need some help. I have this custom column

Occupancy % TMY = (('Almyra Rooms'[Rooms Sold (net of CPL)] * 100) / 'Almyra Rooms'[Capacity]) / 25

and what I want to achieve is where 25 to be the day selected from my slicer.

if it helps to understand what I mean you can see also the MATRIX that holds this value

[Anonymous · Accepted solution]

Occupancy % TMY = var DateDiff = DATEDIFF(
                                 CALCULATE(MIN('Date'[Date]);ALLSELECTED('Date'[Date]));
                                 CALCULATE(MAX('Date'[Date]);ALLSELECTED('Date'[Date]));
                                 DAY)
                  return (('Almyra Rooms'[Rooms Sold (net of CPL)] * 100) / 
                           'Almyra Rooms'[Capacity]) / DateDiff)

But it will work as measure only, not as calculated column...