Ttable data consolidate

[Anonymous]

Hi All,

Have table as mentioned below with Multiple names and Grades.

Name	Grade	Cost
Apple	A	120
Apple	B	90
Apple	A	120
Apple	B	90
Apple	C	80
Apple	D	75
Apple	C	80

Required to consolidate the above table as per the below table.

Name	Grade	Cost
Apple	A	240
Apple	B	180
Apple	C	180
Apple	D	75

Any one can help me!!!

Thanks in advance.

Regards,

Murali

[v-xicai]

Hi  @Anonymous ,

Does that make sense? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

Best regards

Amy

[v-xicai · Accepted solution]

Hi @Anonymous ,

Solution1:

You can just put the column Name, Grade, Cost into Table visual, then set the aggregation of cost as "Sum".

Solution2:

You can create measure like DAX below.

Measure1= CALCULATE(SUM(Table1[Cost]),FILTER(ALLSELECTED(Table1),Table1[Name] =MAX(Table1[Name])&&Table1[Grade] =MAX(Table1[Grade])))

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Nathaniel_C]

Hi @Anonymous ,

Try =sumx(values('Table1 2'[Grade]),'Table1 2'[Sum of Cost]).

or in PBI

Consolidate = sumx(values('Table1_2'[Grade]),SUM(Table1_2[Cost]))

If this helps, consider marking this as the solution! Kudos are nice too.

Nathaniel