4 Replies Latest reply on Aug 31, 2018 10:22 AM by Melissa Fanucci

    Probably something super easy, but I'm stumped: using dimension to filter measure value

    Melissa Fanucci

      Hey there! I have used this calculated field in the past and its worked,

       

      IF [dimension]="Whatever" THEN [measure] END

       

      But in this particular instance I can't get it to work and am officially stumped.

      The data I downloaded has a single field (Total) that records both value in USD and weight in KG. I obviously need to break those two out into separate measures. But for whatever reason, I am failing. Can someone take a look and see what I did wrong?

       

       

      Thank you in advance for any help you can provide!

       

      Melissa