DAX for Remaining Percent Left and Reflect in Bar Graph

Hi third_hicana ,

I hvae modified my sample, please refer to it to see if it helps you.

Measure =
VAR _mindate =
    MINX ( ALLSELECTED ( Sheet1 ), Sheet1[month] )
VAR _vapacityvalue =
    CALCULATE (
        MAX ( Sheet1[Capacity Assigned] ),
        FILTER ( ALL ( Sheet1 ), Sheet1[month] = _mindate )
    )
VAR _project =
    CALCULATE (
        MAX ( Sheet1[project] ),
        FILTER ( ALL ( Sheet1 ), Sheet1[month] = _mindate )
    )
VAR _1result =
    IF (
        MAX ( Sheet1[project] ) = _project,
        MAX ( Sheet1[Maximum Percent] ) - MAX ( Sheet1[Capacity Assigned] ),
        IF (
            MAX ( Sheet1[project] ) <> _project,
            MAX ( Sheet1[Maximum Percent] ) - MAX ( Sheet1[Capacity Assigned] ) - _vapacityvalue,
            BLANK ()
        )
    )
VAR _before =
    CALCULATE (
        MAX ( Sheet1[end date] ),
        FILTER ( ALL ( Sheet1 ), Sheet1[rankx] = SELECTEDVALUE ( Sheet1[rankx] ) - 1 )
    )
VAR _year =
    YEAR ( _before )
VAR _month =
    MONTH ( _before )
VAR _timebigthan =
    IF (
        MAX ( Sheet1[year] ) = _year
            && MAX ( Sheet1[month_column] ) >= _month,
        1,
        0
    )
RETURN
    IF (
        MAX ( Sheet1[_countproject] ) <> 1
            && MAX ( Sheet1[rankx] ) = 1,
        _1result,
        IF (
            MAX ( Sheet1[_countproject] ) <> 1
                && MAX ( Sheet1[rankx] ) <> 1
                && _timebigthan = 1,
            MAX ( Sheet1[Maximum Percent] ) - MAX ( Sheet1[Capacity Assigned] ),
            _1result
        )
    )

I have add other columns, please refer to my pbix file.

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.