cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Till
Resolver II
Resolver II

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

2 ACCEPTED SOLUTIONS

@Till,

 

It seems that you may use ISFILTERED Function in the measure.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Hello,

i will test it and thanks for your help.
Kind Regards
Till

View solution in original post

4 REPLIES 4
v-chuncz-msft
Community Support
Community Support

@Till,

 

Your requirement is not very clear. Better to show us some sample data and expected result.

Measure = AVERAGE(Table1[Goal])
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hey and thanks for the reply,

 

i have a measure for Month Goals.
If i select the month, the Goals are correct.

2017-07-31_191512.jpg

 

 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


@Till,

 

It seems that you may use ISFILTERED Function in the measure.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Hello,

i will test it and thanks for your help.
Kind Regards
Till

View solution in original post

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors