Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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.
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
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.
Hi @Anonymous ,
Try =sumx(values('Table1 2'[Grade]),'Table1 2'[Sum of Cost]).
or in PBI
If this helps, consider marking this as the solution! Kudos are nice too.
Nathaniel
Proud to be a Super User!
User | Count |
---|---|
125 | |
108 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |