Forum Discussion
Tricky Switch and AND Function - combination
Hi Experts I am trying to get the following out come based on the slicer selection criteria.... 1. If the user selects Gross Margin (first slicer) and then Reported (second slicer) then return t...
SWITCH, just like IF, cannot return a table expression.
Have you tried something like this?
SWITCH(TRUE(), ProfitbabilityMeasure = "Gross Margin" && ReportingMeasure = "Reported" , CALCULATE( [GMvPY1% (Reported PY)] , TOPN(10, ALL('Product'[Category]),[GMvPY1% (Reported PY)])
)
, ...
)
Thanks for the excellent feedback,,,
I am guess we need to add RankingContext
))
to th eend of the statement...
got it to work....thanks