Measures in matrix missing values

[luisss]

Hi Guys,

For the start, my visual:

This is a matrix to show some operational KPI's.

My problem:

I have the values for Rooms Available and Room Sold in a table, day by day. Occupancy should be the division of rooms sold by rooms available. I have a measure [actuals] that calculate values for each row:

That is what I have in the measure OCC:

As you can see, there is no value in the Occupancy row (I have no values in the table,). 
I think is because of the row context filter, no ?

I need to keep all the filters active in the slicers also.

What am i missing?

Thank you!

[amitchandak]

@luisss , formula seem fine.

Try these variations

calculate(Sum(A_POWER_BI1202[SL]), filter(all(Esturatura[Rubric]) ,Esturatura[Rubric] = "Room Sold" ))

or

calculate(Sum(A_POWER_BI1202[SL]), filter(all(Esturatura) ,Esturatura[Rubric] = "Room Sold" ))

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[luisss]

Some updates: 
if i use "Rubrica" collum, all works fine( table on the middle) , but if i use"Rubric" not ok. 
What i want if on the blue matrix on the left, show 65.77% in the "Occupancy" row. (nevermind the raged hierarchy, i'll deal with that later 😉 )

Here is the link for pbix file: Pbix 

Thanks

[luisss]

More update:

If i use instead of a calculation (Rooms Solds/Rooms Available) a collum of the Estrututra table it works.

if i use 1500/2 also works!

So the problem is doing the calculation based on the values of the table where are the values of rooms solds and rooms available