Forum Discussion
Calculate average based on column values and selected value in slicers
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
Community SupportHi Anonymous ,
According to your description, I create a sample, Average O is a measure.
As you say, you want the measure dynamically change by the slicers of ProductType, Location and Week.
However, as the measure created from Sales which is in the same table with the slicers, the measure can aotumatically change by the slicers without do anything.
If this is not the problem, could you please explain it more through my sample. I attach it below for reference.
Best Regards,
Community Support Team _ kalyj
If this post helps, then please considerAccept it as the solution to help the other members find it more quickly.
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
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