Forum Discussion
Return sum value based on category
Hi exo,
In the dataset, I would create a field called "Category", which has the row contents of the "Amount" column in your 2nd table, and the when you import that 1st table with the additional "Category" field, create a calculated column with the following dax expression as shown in the screen print below:
That would produce the same output as the "Amount" column in your 2nd table. The important thing is to create a field in the table because color differentiation in the dataset table cannot be properly processed.
Hi Sakiko,
thanks for your reply. However this solution you mentioned is not the one I'm looking for. This is mainly due to a misunderstanding of my question.
The amount column is only for explanation. The Direct in the amount column is already represented in the CC type ("1" value), z is also in the subcategory table, and the total is only for the summed volume amounts. So I do have these values, but these are all in different columns.
Do you have a suggestion based on the above mentioned details?
Thank you for answer in advance!
Hi exo
Does CC type stand for Cost center type? I'd greatly appreciate it if you could tell me what you'd like to achive.
Cc type is for classifying the volume in this case.
Direct means that the operation produces volume, so it's directly correlating to the operation.
Other option is Support, which is for the support cost centers. They are not producing volume, but for the benchmark you have to calculate with the total volume.
3rd mentioned option (z category) is connected to the operation but they also don't have volume. Therefore, you need to take only the amount where z category is showing
My aim is here to come up with a solution where I can have all three options in a single measure. This measure would help me in further calculations.
I hope this helps you a bit.
Thanks for your further explanation, but it would help if you can share with me a sample file with an instruction of what you want to see in a calculated column or a measure output.