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 damit23183,
Do you mean that when you use service name as slicer filter condition , the total average value displayed is incorrect ? The value of field value% on visual is from the value obtained by the formula AVERAGE (Fac_Incident [Fac_Incident . ResolutionTTR%]? Can you provide some sample data of the three tables you mentioned(Fac_Incident , Customer Experience and another table ) and the created relationships between this 3 table ?
Best Regards
Rena
Hi,
As you can see below, ConfigItem (Service Table) joined with Fact table on ConfigItem column.
And Fact table and Customer experience (Result Table from Sharepoint) joined on Customer Experience column which is custom column created by me with value 1000 in both table. The reason is there is no relationship between this two table, that's reason why i have applied SWITCH function to put correct value in front of correct Metric Name.
Both Joins are Many to Many with BOTH cross Filter direction.
Thanks
Hi,
Thank you for your response.
However, this has been solved now it was SWICH formula where i did make one mistake but after applied correct syntax it worked perfectly fine.
Thank you all for your support really appreciate it.
Thanks
Hi damit23183 ,
Could you please mark this post as Answered since the problem has been resolved by yourself? Thank you.
Best Regards
Rena