Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have this table
Class | Category | Cost |
A | CPU | 4 |
A | Memory | 3 |
A | Network | 10 |
A | Disks | 2 |
B | CPU | 4 |
B | Memory | 10 |
B | Disks | 11 |
And the table I want is to add rows of CPU and Memory for each Class and at last it turns out like this. How can I do this?
Class | Category | Cost |
A | CPU&Memory | 7 |
A | Network | 10 |
A | Disks | 2 |
B | CPU&Memory | 14 |
B | Disks | 11 |
Solved! Go to Solution.
Hi, @zzzsharepoint
You can try the following methods.
Column:
New Category = IF(OR([Category]="CPU",[Category]="Memory"),"CPU&Memory",[Category])
Sum Cost =
CALCULATE ( SUM ( 'Table'[Cost] ),
FILTER ( 'Table',
[Class] = EARLIER ( 'Table'[Class] )
&& [New Category] = EARLIER ( 'Table'[New Category] )
)
)
New Table:
New table = SUMMARIZE('Table','Table'[Class],'Table'[New Category],'Table'[Sum Cost])
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @zzzsharepoint
You can try the following methods.
Column:
New Category = IF(OR([Category]="CPU",[Category]="Memory"),"CPU&Memory",[Category])
Sum Cost =
CALCULATE ( SUM ( 'Table'[Cost] ),
FILTER ( 'Table',
[Class] = EARLIER ( 'Table'[Class] )
&& [New Category] = EARLIER ( 'Table'[New Category] )
)
)
New Table:
New table = SUMMARIZE('Table','Table'[Class],'Table'[New Category],'Table'[Sum Cost])
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@amitchandak I checked the video what you have shared and that has no where with the question asked. I am not looking to summarize all the rows here.. its only one with values CPU and Memory and also looking to add the Cost for these values. I am looking to get that as a new table. Your Video talks about summarize function which I cant use here. Please check the question and respond.
@zzzsharepoint , use the power query and table method
Concatenate Text- Measure, DAX Table, and Power Query Table: https://youtu.be/xAh3tz1qo24
And I am looking to Add two values not just concatenate two strings
Can you please show with an example?
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |