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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous , try measure like

 

Average OEE_1 = Switch(selectedvalue(Slicer[value),
"Product Type", AVERAGEX(VALUES(Deliver_O[ProductType]), CALCULATE('Measure'[Average O])),
"Location" , AVERAGEX(VALUES(Deliver_O[Location]), CALCULATE('Measure'[Average O])),
"Week", AVERAGEX(VALUES(Deliver_O[Week]), CALCULATE('Measure'[Average O]))
)

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thanks Amit,

     

    In first line "slicer" is greyed out for me, I am not sure if I am doing something wrong or not.

     

    Those Product type, location in commas are to display something?