Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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
@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
Thanks, I will take a look at this.
User | Count |
---|---|
12 | |
12 | |
8 | |
8 | |
6 |
User | Count |
---|---|
27 | |
19 | |
14 | |
11 | |
7 |