Continuous Percntages value conversion into a different range

[kamalbandam]

 I have percentage from with a measure x  0 - 100. I want to make this break into different ranges and make it use a slicer so that I can slice in between the ranges i.e 1-10, 10-30, 40-70,70-100. But the percentages are in the form of measure x. I have written an if condition to create the ranges. Since It is an measure it won't allow in a slicer. So I need to make it as a column but the measure x can't be as column. How do I relate this measure x to a column

Anyone could you please help me with this.

Thanks in Advance,

Kamal

[nandukrishnavs]

@kamalbandam  Please provide a sample data set, and measure logic. then expected output. 

[kamalbandam]

Hi @nandukrishnavs 

Please download the pbix sample form https://filebin.net/hkxo3gmkp2ptci1x
Please change the extension to .pbix if it  downloads as Zip.
The ouput expected as follows:

Thanks & Regards,

Kamal

[nandukrishnavs · Accepted solution]

@kamalbandam 

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

Sample table

Name	Contribution
A	10.00%
B	30.00%
C	50.00%
D	70.00%
E	20.00%

Range table

Range

0-20

21-40

40 above

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 🙂

[kamalbandam]

Great Solution. It worked very well.

Thank you very much

[nandukrishnavs]

@kamalbandam 

You could try what-if parameter.

https://docs.microsoft.com/en-us/power-bi/desktop-what-if

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

[kamalbandam]

Hi @nandukrishnavs ,

This didn't work.

Could you please tell me another solution if any.