Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |