7 Replies Latest reply on Jul 26, 2018 9:55 PM by Saharat Sakulsaowapakkul

    Create AVG[Sales] of [Store Name] whose [Bkk Upc] = "BKK"

    Saharat Sakulsaowapakkul

      Hi All

       

      I have Dimensions of store, its location whether in "BKK" or "UPC" and measure sales

       

      I want to create FIXED value of measure under logic "Average sales of store within BKK"

       

      In other word, I want a fix measure of value 2,555,971 where ever its dimensions are

      but (2,555,971 also have to be adjusted according to data lake)

       

      You may kindly give me a HOW TO or else revise me an attached workbook.