Forum Discussion

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
3 years ago
Ah okay so the final average needs to be an average of the average measure,

try looking at these:

https://community.powerbi.com/t5/Desktop/Average-of-measure/td-p/50935
https://community.powerbi.com/t5/Desktop/calculate-average-of-calculated-measure/td-p/568198

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Sudharsanan

Helper III

3 years ago

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

DOLEARY85

Resident Rockstar

3 years ago

Ah okay so the final average needs to be an average of the average measure,

try looking at these:

https://community.powerbi.com/t5/Desktop/Average-of-measure/td-p/50935

https://community.powerbi.com/t5/Desktop/calculate-average-of-calculated-measure/td-p/568198

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Forum Discussion

Variable Table and measure calculation

Related content

Dynamic Variable in Calculated Columns

DAX Calculated Measure

Understanding variable calculation

DAX Measure for Ranking the valid rows and calculating the average rating

Measure or Calculated Column