Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have the following table and I would like to use set analysis to include only ID's where all of the measures are > 0. Does anyone have any suggestions?
ID Measure 1 Measure 2 Measure 3
1 10 0 5
2 5 5 5
3 0 3 6
4 10 15 20
So ideally my resulting table would be
ID Measure 1 Measure 2 Measure 3
2 5 5 5
4 10 15 20
Thanks!
Mark
try this
Count({< Field= {"=Sum(Sales) > 0"} >} DISTINCT Field)
Hi,
the set analysis part on your expression(s) would be this:
{<ID={"=Sum(MeasureX)>0"}>}
May be this
Sum({<ID = {"=RangeMin(Sum([Measure 1]), Sum([Measure 2]), Sum([Measure 3])) > 0"}>}[Measure 1])
Sum({<ID = {"=RangeMin(Sum([Measure 1]), Sum([Measure 2]), Sum([Measure 3])) > 0"}>}[Measure 2])
Sum({<ID = {"=RangeMin(Sum([Measure 1]), Sum([Measure 2]), Sum([Measure 3])) > 0"}>}[Measure 3])