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 with the taget values in the table.
For example:
IF(AND(Rohdaten[TOPIC]="TOPICXX";Rohdaten[Monat]<=4);490;IF(AND(Rohdaten[TOPIC]="TOPICXX";Rohdaten[Monat]>4);480)
If i filter in the Matrix after the Calendarweek or the Month only the average value is displayed.
Please help, thank`s
Till

Need Help

4 Replies

  • 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