Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Aggregate percentage column

Hallo Everyone,   I am trying to calculate two columns for the Aggregation and value% of total as of the last two columns in the picture.  The aggregation must be based on the Name, product name ,...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous ,

     

    Create 2 measures as below:

     

    aggregation = SUMX(FILTER(ALL('Table'),'Table'[Name]=MAX('Table'[Name])&&'Table'[branch]=MAX('Table'[branch])&&'Table'[product name ]=MAX('Table'[product name ])),'Table'[value])
    value% of total = DIVIDE(MAX('Table'[value]),[aggregation])

     

    And you will see:

    For the related .pbix file,pls click here.

     

    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!
amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous , Try

 

Measure = divide(Sum(Table[Value]),sum(Table[Aggregation ]))

Anonymous's avatar
Anonymous
Not applicable
6 years ago

amitchandak Thank you for your answer, sorry I was not so clear. I am trying to calculate these two columns Aggregation and value%of total.