Filtering a Calculated Measure

[krrish116]

Hi @amitchandak ,

First of all Thank you for helping me and lot of people with your Answers in Power BI community..

If i Search something then most of the community answers are yours only.

Coming to My Issue,

I have created a measure 

Measure= IF( [Spend] = 0, "NA",
             IF([Value] > [ Spend],"NA",
             DIVIDE( [ Value],[Spend])
            ) )

The Measure is working fine and now i want to show the values of measure >30 and < 100 by using a slicer.

Can you help me out in solving this.

Thanks,

Krishh

[amitchandak · Accepted solution]

@krrish116 , At first look, it look like a case of segmentation using an independent table- https://www.youtube.com/watch?v=CuczXPj0N-k

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[krrish116]

Got it Thank you..

[krrish116]

Hi,

Please sort this issue

Measure= 

IF(

   [Spend] = 0, Blank(),

    IF(

        [Value] > [ Spend],Blank(),

        DIVIDE( [ Value],[Spend])

     )

)

Product	Spend	Value	Measure
ACIDS	22562959	5997699	27%
ADDITIVE PREBLENDS	10200000	51927	1%
ADDITIVES OTHER	929899	81964	9%
ALKALINE (CAUSTIC)	25050000	7791208.6	31%
ANTIBLOCS	1214000	13471	1%
ANTIOXIDANTS	3064303.38	91118	3%
ANTISTATS	4616000	169965	4%
BAGS	62750	29000	46%
CATALYSTS	7600000	1075000	14%
CHEMICALS FOR POLYMER CATALYST PRODUCTION	885000	226852.3366	26%
CORRUGATED	262000	100	0%
DRUMS	1007000	138000	14%
ELASTOMERS	29677998.4	2016577	7%
FILLERS OTHER	200000	10000	5%
FLAME RETARDANTS	36370	6596	18%
GLASS FIBRE	15468827	911965	6%
LIGHT STABLIZERS	54837	4126	8%
METAL ALKYLS	1073100	39186.70502	4%
MONOMERS	70100000	4900000	7%
PALLETS	44932	940	2%
PEROXIDES	950000	36087.6	4%
PIGMENT CONCENTRATES	26192650.17	3073428.04	12%
PIGMENTS	28295710.51	1903241.717	7%
POLYAMIDE	27075280	1610518.44	6%
POLYESTER	570000	2567	0%
POLYETHYLENE	23267152	1580458.28	7%
POLYMERS OTHER	587643	6750	1%
POLYPROPYLENE	123226675.6	6101253.04	5%
SLIP AGENTS	165933	2835	2%
SPECIALTY PACKAGING MATERIALS	60900	163000	268%
WATER AND PROCESS TREATMENT	3519000	839000	24%

So here i have to create a button. where if they click on that button, the measure

has to show values from 30 to100 % ..

So please help me out in doing this @amitchandak 

Thanks,

Krish..