Forum Discussion

Sudharsanan's avatar
Sudharsanan
Icon for Helper III rankHelper 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
Icon for Resident Rockstar rankResident 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
    Icon for Helper III rankHelper III
    3 years ago

    Thanks DOLEARY85 for quick response,

     

    but i am not getting the answer as i expected.

    • DOLEARY85's avatar
      DOLEARY85
      Icon for Resident Rockstar rankResident Rockstar
      3 years ago

      Do you have any more info - can you share what you're seeing?

      • Sudharsanan's avatar
        Sudharsanan
        Icon for Helper III rankHelper III
        3 years ago

        DOLEARY85 i am getting a value of 73.65, but i need to get 76.94296