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.
If i filter in the Matrix after the Calendarweek or the Month only the average value is displayed.
Please help, thank`s
Solved! Go to Solution.
Your requirement is not very clear. Better to show us some sample data and expected result.
Measure = AVERAGE(Table1[Goal])
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?
Learn how to create your own user groups today!
Click here to read more about the October 2021 Release!
Mark your calendars and join us for our next Power BI Dev Camp!