Forum Discussion
Average formula
Hi damit23183 ,
Could you please mark this post as Answered since the problem has been resolved by yourself? Thank you.
Best Regards
Rena
Hi,
Thanks for quick response.
So far data are correct just drilldown option is not working on page.
Result are not expected when i select any service it keep getting same number but SCORE should change if i choose any particular service. For example; please see expected result below;
| Service Name | %Value |
| AAMI | 0.87 |
| CUG | 0.85 |
| PUG | 0.84 |
| AURORA | 0.81 |
| Total Average | 0.83 |
As you can see above total average is 0.83 so i am only getting 0.83 whenver i select any service.
But, i would like to see 0.87 when i select AAMI and 0.81 when i select AURORA.
Hope this will enough detail however if you need more please let me know.
Thanks
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.
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