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?
Check out the News & Announcements to learn more.
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Microsoft received the highest score of any vendor in both the strategy and current offering categories.
DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.