When i roll up the Data i still want my calculated field to work by site by date

[Thomas_Meath]

I have created a data set which looks at site by date. I have created a formula within the data to highlight where we are full and where we are not full:

Full = IF ( 'Booking Date'[% Occ TY] >=0.95,"Y","N")

This works fine if the data is split out to site by date, however when i want to roll up the data and look at how many days, how much revenue is produced on full days vs non full days the formula doesn't work and just calculated for the current selection.

Please can someone help me on this one?

Regards Thomas

[Greg_Deckler]

@Thomas_Meath This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

[Thomas_Meath]

Thanks, I will take a look at this.