Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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