Forum Discussion
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 ,...
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,
KellyDid I answer your question? Mark my post as a solution!
Anonymous have you tried my answer?