cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper 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

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Measure for Goals

@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

Highlighted
Helper II
Helper II

Re: Measure for Goals

Hello,

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

View solution in original post

4 REPLIES 4
Highlighted
Community Support
Community Support

Re: Measure for Goals

@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.
Highlighted
Helper II
Helper II

Re: Measure for Goals

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


Highlighted
Community Support
Community Support

Re: Measure for Goals

@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

Highlighted
Helper II
Helper II

Re: Measure for Goals

Hello,

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

View solution in original post

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors