Forum Discussion

Till's avatar
Till
Resolver II
9 years ago
Solved

Measure for Goals

Hello, I`m new in Power BI and a beginner with DAX. For our Call-Center i need for the AHT KPI (Avarage Handling Time) variable Goals for each month and Calendar Weeks I habe generated a column wi...
Need Help
  • Till's avatar
    Till
    9 years ago

    Hello,

    i will test it and thanks for your help.
    Kind Regards
    Till

v-chuncz-msft's avatar
v-chuncz-msft
Community Support
9 years ago

Till,

 

Your requirement is not very clear. Better to show us some sample data and expected result.

Measure = AVERAGE(Table1[Goal])
  • Till's avatar
    Till
    Resolver II
    9 years ago

    Hey and thanks for the reply,

     

    i have a measure for Month Goals.
    If i select the month, the Goals are correct.

     

     Now, i select the Week and the goals displayes as Average from the month.
     I think something is wrong with my Dax-Measure. I have different goals per month.
    Goal=if(and(TOPIC="XX";MONTH=1);438;IF(AND(TOPIX="XX";MONTH=2);420 ... etc.
    What have i do, to show the Goals correct for the weeks?
    Thanks
    Till


      • Till's avatar
        Till
        Resolver II
        9 years ago

        Hello,

        i will test it and thanks for your help.
        Kind Regards
        Till