Forum Discussion

SUMESHKUMAR22's avatar
SUMESHKUMAR22
Icon for Helper IV rankHelper 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.

     

SUMESHKUMAR22's avatar
SUMESHKUMAR22
Icon for Helper IV rankHelper IV
3 years ago

Hi Greg_Deckler , Anonymous 

Below is the total average (Result), I'm expecting in your above measure.
The blank that is coming shouldn't come up and give the total result as 48.70% .



Thanks in advance!

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
3 years ago

Hi,

You may download my PBI file from here.

Hope this helps.