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

    Set analysis filtering

    Magnus Buseth

      Hi,

       

      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:

      no_selection.JPG

       

      With selection:

      with_selection.JPG