Continuous Percntages value conversion into a different range

kamalbandam 

Due to the privacy issues, I'm unable to download your pbix file.

Sample table

Range table

Create a DAX measure.

Filter =
VAR _range =
    SELECTEDVALUE ( RangeTable[Range] )
VAR _per = ContributionTable[Contribution Sales %]
VAR _filter =
    IF (
        _range = "0-20",
        IF (
            _per > 0
                && _per < .21,
            "Required",
            "Not Required"
        ),
        IF (
            _range = "21-40",
            IF (
                _per > .20
                    && _per < .41,
                "Required",
                "Not Required"
            ),
            IF (
                _range = "40 above",
                IF (
                    _per > 40,
                    "Required",
                    "Not Required"
                )
            )
        )
    )
RETURN
    _filter

Apply this measure as a visual level filter. 

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂