I have this set analysis:
= IF(GetSelectedCount([location], True(), 'StateA'), Sum({[StateA]<item_desc= {"*source*"}>} qty) / (Sum({[StateA]<item_desc-= {"*damaged"}>} qty)))
This is a measured field in a straight table. It works fine when I create a filter pane and assigning state A to this filter pane.
However, I want this sum to take in a filter condition from column "Model" from the default state. Therefore, the expected outcome will be when user did not select any "Model", the SUM will show the whole table calculation. But when user select "Model" and the filter from state A, the calculation will then SUM based on these two (kind of like AND OR).
Is it possible to add two alternate state in this SUM?