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 ,
Thanks for prompt response!
The final total avergae should come up 48.70% instead of 49.56% . As we will not consider the repetitve percentage values as per the Table[a] disitnct values.

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.