6 Replies Latest reply: Oct 16, 2017 5:01 AM by Jonathan Dienst RSS

    Set analysis filtering



      I have a question about filtering in set analysis.Let's say I have a table with two columns, ProductID and Sales


      I create a KPI with the following measure:

      Sum({$<ProductID={10}>} Sales)


      When no selection is made, it gives 1872.


      If I make any selection on ProductID, e.g. ProductID = 3, it is still 1872, while I would expect it to be zero, as all sales with ProductID 10 are supposed to be excluded?


      Is this the correct behavior?


      No selection:



      With selection: