Forum Discussion

Sudharsanan's avatar
Sudharsanan
Helper III
3 years ago
Solved

Variable Table and measure calculation

Hi All,   I have a case where i need to group a set of data and bring the average.    Below is my dataset and i need to group the products to have the sales and qty value and then i need to Avg. ...
Need Help
DOLEARY85's avatar
DOLEARY85
Resident Rockstar
3 years ago

Hi,

 

this measure should work for the sum:  

Measure = CALCULATE(sum('Table'[Sales]),ALLEXCEPT('Table','Table'[Product]))
 
just create a 2nd one for QTY.
 
For the average:
 
Measure 2 = CALCULATE(AVERAGE('Table'[Sales]),ALLEXCEPT('Table','Table'[Product]))
 
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Sudharsanan's avatar
Sudharsanan
Helper III
3 years ago

Thanks DOLEARY85 for quick response,

 

but i am not getting the answer as i expected.