measure value should not change based on the slicer selected

[Anonymous]

Hi,

Pleas help me

Below is my dataset.

I am looking to create 2 measures 

Measure 1 = Calculte(Sum(Sales),filter(Sales Type)= "SMD" ---  This will work with all the slicers from the table

Measure 2 = Calculte(Sum(Sales),filter(Sales Type)= "SMD", filter(Maker) ="Pepsi"-- This works as above but slicer should not work

for column Maker.

Slicers (Column Names ) : Slicer_1 = Maker

                                          Slicer_2 = Category

Measure 1 will change as per the slicers selected

Measure 2 should not change when slicer_1 is selected and will change when Slicer_2 is selected.

Date	Maker	Category	Sales Type	Sales
01/01/2022	Pepsi	SD	CVS	12
01/01/2022	MZ	SD	SMD	17
01/01/2022	CZ	SD	CVS	17
01/01/2022	CC	SD	SMD	12
01/02/2022	Pepsi	SD	CVS	19
01/02/2022	MZ	SD	SMD	13
01/02/2022	CZ	SD	CVS	14
01/02/2022	CC	SD	SMD	20
01/03/2022	Pepsi	SD	CVS	16
01/03/2022	MZ	SD	SMD	11
01/03/2022	CZ	SD	CVS	14
01/03/2022	CC	SD	SMD	19
01/04/2022	Pepsi	SD	CVS	19
01/04/2022	Pepsi	SD	SMD	10
01/04/2022	MZ	SD	CVS	17
01/04/2022	CZ	SD	SMD	12
01/05/2022	CC	SD	CVS	11
01/05/2022	Pepsi	SD	SMD	18
01/05/2022	MZ	SD	CVS	19
01/05/2022	CZ	SD	SMD	19
01/01/2022	CC	PP	CVS	10
01/01/2022	Pepsi	PP	SMD	14
01/01/2022	MZ	PP	CVS	15
01/01/2022	CZ	PP	SMD	16
01/02/2022	CC	PP	CVS	19
01/02/2022	Pepsi	PP	SMD	15
01/02/2022	MZ	PP	CVS	14
01/02/2022	CZ	PP	SMD	19
01/03/2022	CC	PP	CVS	20
01/03/2022	Pepsi	PP	SMD	18
01/03/2022	MZ	PP	CVS	19
01/03/2022	CZ	PP	SMD	13
01/04/2022	CC	PP	CVS	20
01/04/2022	Pepsi	PP	SMD	11
01/04/2022	MZ	PP	CVS	11
01/04/2022	CZ	PP	SMD	16
01/05/2022	CC	PP	CVS	12
01/05/2022	Pepsi	PP	SMD	10
01/05/2022	MZ	PP	CVS	10
01/05/2022	CZ	PP	SMD	13

[TonyZhou1980]

Try to apply below for Measure 2 and see it meets your requirement,

Measure 2 =

    CALCULATE(

        sum(Table[Sales]),

        KEEPFILTERS(Table[Sales Type]="SMD"),

        KEEPFILTERS(Table[Maker]="Pepsi")

    )

[Mikelytics]

Hi  @Anonymous 

Can you please try the following:

For "Table" please put in your table name.

Measure 2 = 
CALCULATE(
   SUM(Table[Sales]),
   FILTER(Table,[Sales Type]= "SMD"), 
   Table[Maker]="Pepsi"
)

Best regards

Michael

-----------------------------------------------------

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

Appreciate your thumbs up!

@ me in replies or I'll lose your thread.

-----------------------------------------------------

LinkedIn

[Arul]

@Anonymous ,

you need to use REMOVEFILERS in the measure and bring the field [Maker] which you are using in the slicer.
I belive you have to change the existing syntax of the measure slightly to make it work properly. Refer the modified code and make the changes based on your need and let me know if you need any help.

Measure 2 = CALCULATE((Sum(Sales),filter(<table>,Sales Type)= "SMD", filter(<table>,Maker) ="Pepsi",REMOVEFILTERS(<table>[Maker]))

 Thanks, 

[Anonymous]

@Arul Thanks for your replay,

I am getting the below error.

[Arul]

@Anonymous ,

try the excat formula attached below,

Sales for SMD =
CALCULATE (
    SUM ( 'Table'[Sales] ),
    SalesType = "SMD",
    Maker = "Pepsi",
    REMOVEFILTERS ( 'Table'[Maker] )
)

Thanks,

[Anonymous]

@Arul ,

Thanks again !

But this is not working as expected 

image 1

Image 2

Wehn I select something expect Pepsi from Maker slicer data is going blank.