1 Reply Latest reply: Dec 13, 2016 8:15 AM by Gysbert Wassenaar RSS

    Filtering data in a dimension and in associate charts

    Christian Cutruneo

      Hi,

      I have a probem with filtering dataset of a dimension.

       

      I have a chart with 1 domension (Dim1) e 1 Measure (Mes1).

      I want to select only Dim1 that have Dim2="Physical" (The Dim2 can have value "Physical" or "Financial").

       

      In measure of the chart I have type this expression SUM({<Dim2={"Physical"}>}[Mes1]).

       

      The problem is that I see in the chart also the element for Dim2="Financial" (with value = 0).

       

      What can I do for remove this elements from the chart?

       

      Thanks

      Christian