Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Moving Benchmark

Hi All,
please I have hit a little snag .. I have a formula that was supposed to calculate the water consumption weekly
but the benchmark I want to be flexible depending on the number of persons available in that week. 
 columns :
Average headcount
week number

KPI's 

 

one person is assumed to consume a minimum of 1.5 liters weekly

 

NW Benchmark = Calculate(sumx(FASENV,FASENV[headcount]*1.5),filter(FASENV,FASENV[Location] in{("Average Head Count - Staff House I"),("Average Head Count - Staff House II"),("Average Head Count - Staff House III"),("Average Head Count - Staff House IV"),("Average Head Count - Office")}))

 

Kindly assist avanderschilden Anonymous HotChilli Nathaniel_C 

benchmark
Data Modeling
DAX
DAX filter formula
DAX Query
POWER BI Dax rules
Report

4 Replies

  • Nathaniel_C's avatar
    Nathaniel_C
    Community Champion
    6 years ago

    Hi Anonymous ,

    One thing I notice off the top is a typo. Is this your actual code?

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
    Nathaniel

     

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      still didnt not work.

       

       yes, this is my code. 

       

      Even with the brackets, it worked. but it not populating the benchmark to be dynamic 

      has the average headcount for various weeks and locations differ 

       

       

       

      kindly assist