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

damit23183's avatar
damit23183
Microsoft Employee
6 years ago

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
AAMI0.87
CUG0.85
PUG0.84
AURORA0.81
Total Average0.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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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

  • damit23183's avatar
    damit23183
    Microsoft Employee
    6 years ago

    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi damit23183，

      Could you please provide your PBIX file if it is convenient?

      Best Regards

      Rena

      • damit23183's avatar
        damit23183
        Microsoft Employee
        6 years ago

        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