Forum Discussion
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!
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
- amitchandak
Super User
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.] ) - AnonymousNot applicable
Excellent! Worked perfect. Thanks so much amitchandak