5 Replies Latest reply on Nov 12, 2018 4:01 PM by Shinichiro Murakami

    Distinct Count with if statement

    anuj agrawal

      Hello all,

       

      I am stuck and would really apreciate some help. I am ataching a mock excel data file. The file has site(Dimension), GEDBNO(Dimension), balance(measure),prediction(Measure), and ratio (calculated measure). What i want to achieve is count the distinct number of GEDbno within a site that meets a condition. I have a parameter called "Balance". I would like to count disctinct of all the GEDBNo in a site when ratio < = Balance(parameter). i have tried some solutions in the forums but nothing seems to be working.Please advise.