calculate total for every each row per multiple values

[Anonymous]

I want for each ID (row) to show a total for (column_name_1) calculated by (column_name_2) and (column_name_3)
i ask for ideas how to do it
thanks

[dax]

Hi galina,

I don't know your data sample, so if possible, could you please inform me in details?

Below is my design, if this is not what you want, please correct me and inform me your data sampel and expecting output

name	id	cost	quantity
a	1	10	2
a	2	5	1
a	3	3	5
a	4	2	4
b	1	5	3
b	2	6	1
b	3	2	2
b	4	3	1
c	1	1	2
c	2	2	3

you could create a column like below

Column = sumtotal[cost]*sumtotal[quantity]

then add this in Matrix

Best Regards,
Zoe Zhi

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

[Anonymous]

I want a different total for each row.

the columns are those:

'TableName'[1st year]
'TableName'[Group]="CAPEX",

'TableName'[Group]="OPEX",
'TableName'[Type]="Indicative"

'TableName'[Type]="Estimation"
'TableName'[ID]

I want to get something like that:

id|1st year|Indicative|CAPEX

[dax]

Hi 

If possible, could you please inform me more detailed information(sample data and expecting output)?

Please do mask sensitive data before uploading.

Thanks for your understanding and support.
Best Regards,
Zoe Zhi