Forum Discussion

weisheng's avatar
weisheng
Frequent Visitor
8 years ago

Using aggregated value in a calculation.

Hello all,   I am relatively new to Power BI.    In my current project, I have a column of monthly usage. I know that I can pick different aggrated values such as Sum, or Average and it will show...
weisheng's avatar
weisheng
Frequent Visitor
8 years ago

Thanks ! But I am looking to get the value in the red circle and I have a slicer that picked a specific product. So your equation actually returns the average of every monthly usage amonst all product. Im not sure if I am explaining it well.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

weisheng yeah not sure if I can understand from your explanation, you need to provide better raw data, and examples of what is the output you need or provide a power bi other it is impossible to give the right ans in first go.

 

I am going to take another shot in the dark and say but if you want specific to a product then you use

avg of monthly usage by product = calculate(avg(table1[monthly usage]),allexcept(table1,table1[product]) 

 

if you just want the avg of monthly usage and then have it filtered by multiple slicers try this one

 

avg of monthly usage = calculate(avg(table1[monthly usage]),allselected(table1))