Create two columns one Static and one Dynamic off Slicers

[Anonymous]

Hi,

I want to create two columns in a matrix that has one that is static and not affected by a slicer and one that is dynamic based off the slicer. I tried creating a New Table with two groups "All" and "Selected Dealers" I was going to put this filter in around these two groups. Can someone help with this logic?

Thanks!

Net Profit $ CY Avg, Whole Group =

CALCULATE(

[Net Profit $ CY Avg.]

,if('Selected Groups'[Groups] = "All",

ALL(DealerMonthlyFinancials[Dealer Number])

))

[Anonymous]

Excellent! Worked perfect. Thanks so much @amitchandak 

[amitchandak · Accepted solution]

@Anonymous , Try like, new measure

Net Profit $ CY Avg, Whole Group =
,if(selectedvalues('Selected Groups'[Groups]) = "All",
CALCULATE(
[Net Profit $ CY Avg.],
ALL(DealerMonthlyFinancials[Dealer Number])
) , [Net Profit $ CY Avg.] )