Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Create two columns one Static and one Dynamic off Slicers

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 , 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.] )

2 Replies

  • 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.] )