Sorry for the inconvinience and again thank you for your follow through. I can't say thank you enough. The dashboard I want to create will look something like the attached image.
OK so let's say we have in the slicer the following:
What would be the result for each of the three measures you want? Explain conceptually how it would be calculated so that I can understand if I missed something earlier?
My gauges would show:
Sorry if this is a repeat reply (had internet connectivity problems from home this moring).
Ok, so for the min and max we would be looking at the month February of all years in your data. Correct?
Yes, that is correct.
OK, then we need to update the [Passengers] measure we had before to ignore the year:
Passengers = CALCULATE ( SUM ( 'FT Passengers'[Pax] ); ALL ( CalendarTable[Year] ) )
With that I think you should be able to build your gauges. If you need more variations on what to consider from the slicers and what not, you'd need to update the measures again.
Ahhh.... I'm my own worst enemy. I was explecting something complicated. I guess I was over engineering it. Big thanks AIB. I'll give it a try hopefully sometime today.