Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
It seems that you may use ISFILTERED Function in the measure.
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?
Thanks
Till
It seems that you may use ISFILTERED Function in the measure.
Hello,
i will test it and thanks for your help.
Kind Regards
Till
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
77 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |