Forum Discussion

damit23183's avatar
damit23183
Microsoft Employee
6 years ago
Solved

Average formula

Hi,   Need help with AVERAGE formula,   I would like to calculate below condition,   ID                   ServiceName        %Value     --> Column Name 1                             A         ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi damit23183 ,

    Could you please mark this post as Answered since the problem has been resolved by yourself? Thank you.

     

    Best Regards

    Rena

d_gosbell's avatar
d_gosbell
Super User
6 years ago
damit23183 wrote:

i am only getting 0.83 whenver i select any service.

Oh so if you are seeing the total value repeated for every service and you are using the formula: AVERAGE(Fac_Incident[Fac_Incident.ResolutionTTR%]) that means you do not have a relationship between Fac_Incident and the table with the [Service Name] column (or the relationship is inactive or in the wrong direction). If you fix the relationship I think this should start working.

damit23183's avatar
damit23183
Microsoft Employee
6 years ago

Hi,

 

There is a relationship between Fact table and service table which i have set up in Data model.

 

However, final table where results are showing does not have direct relationship with any table. Therefore, i did create one custom column in Fact Table and Result table with 1000 value in it, and joined both table with that custom column.

 

If i do drilldown seperately without result table then its works fine....between Fact and Service table.

Which i means when i select specific service i get specific result value from fact. As soon as include result table its not working.

 

Thanks