Forum Discussion

SUMESHKUMAR22's avatar
SUMESHKUMAR22
Helper IV
3 years ago
Solved

Calculate average based on same category

Hi Everyone, Good day! As per the below snapshot I want to create a new measure where the marked percentage numbers should get averaged beacuse it lies under the same category of column A but colum...
DAX
DAX Averages
Ideas
power bi
  • Ashish_Mathur's avatar
    Ashish_Mathur
    3 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

hello SUMESHKUMAR22 ,
please try:

 

margin average = CALCULATE(AVERAGE(powerbi[Margin]),ALLEXCEPT(powerbi,powerbi[a]))

 

 

 

  • SUMESHKUMAR22's avatar
    SUMESHKUMAR22
    Helper IV
    3 years ago

    Hi Anonymous ,
    This is coming up fine at category level. But in the total average instead of 49.56% it should come up 48.70%. That is dividng the average by distinct table[a] values.

    Thanks you!