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"...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

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