Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Calculate average based on column values and selected value in slicers

Hi All,   I am working on calculating average for one of my dashboard, I want average to be calculated as selected value of slicer.   Let say I have one column of product type, another column of ...
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi v-kalyj-msft,

     

    I am attaching the screenshot of my sample data in excel, When I am using simple average dax formula, I am getting correct results for first two tables in screenshot but when i am selecting multiple location in slicer(washinton+London) the value is not matching.

     

    I have attached both screen shot for excel and for PBI also

     

    ExcelPBI

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi v-kalyj-msft,

 

I am attaching the screenshot of my sample data in excel, When I am using simple average dax formula, I am getting correct results for first two tables in screenshot but when i am selecting multiple location in slicer(washinton+London) the value is not matching.

 

I have attached both screen shot for excel and for PBI also

 

ExcelPBI

v-yanjiang-msft's avatar
v-yanjiang-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi Anonymous ,

What's the formula of OEE measure? Why the average of (0.63264, 0.62643, 0.60761, 0.62469) is not 0.62167.

Best Regards,
Community Support Team _ kalyj