Donut: Default to 100% when Actual/Primary Value Exceeds 100%

[samdep]

Hi Community,

I am building a dashboard that looks at hours logged over the course of a month vs. available man hours. 

First measure counts working days within the month, the next measure uses a what-if parameter to generate the available man hours based on the headcount selected.

Everything is working perfectly... My problem is that I'd now like to showcase available time used (either in hours or %) via a donut/circle, but in the scenario where the logged hours exceeds available man hours, the % exceeds 100 and I get the error message of primary value exceeds max value.

This isn't an issue with the KPI card, it simply reflects 120% or whatever the case may be... I've tried manually putting in 1.0 as the max value and I also tried a DAX measure of:

IF(Logged Hours (Measure) > Available Hours (Dynamic Measure Based on What-If Param), Available Hours, Logged Hours).

I'd really like to include this visual, but cannot seem to make it work -- I keep getting the error message of primary value exceeds max value, but I would think that the IF/THEN measure I created could be inserted into the Max Value field -- defaulting to 100% or the total hours logged if the total hours (or %) exceeds the available hours or 100%.

Really appreciate any guidance. Thanks! 

[lbendlin · Accepted solution]

You can modify your measure using the MIN() function

MIN (Available Hours, Logged Hours)  will give you the logged hours as long as they are less than the available hours. If the logged hours exceed the available hours the measure will instead return the pegged value of the available hours.