Forum Discussion
User defined upper bound on percentage forecast?
Greetings. I'm brand new to Power BI so forgive me if this is answered elsewhere (I couldn't find it if so). I have a simple line graph that shows my percentage occupancy value measure by month....
Yeah, ok. I currently have it as a super simple measure:
Occupancy = [Occupied Units]/DISTINCTCOUNT([Unit Number])
I tried wrapping this in a MIN function: MIN([Occupied Units]/DISTINCTCOUNT([Unit Number]),1). I think that should work in my mind's eye. My forecast still goes beyond 100% though.