cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
galina Frequent Visitor
Frequent Visitor

calculate total for every each row per multiple values

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

3 REPLIES 3
Community Support Team
Community Support Team

Re: calculate total for every each row per multiple values

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

280.PNG

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.

galina Frequent Visitor
Frequent Visitor

Re: calculate total for every each row per multiple values

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

Community Support Team
Community Support Team

Re: calculate total for every each row per multiple values

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

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 126 members 1,382 guests
Please welcome our newest community members: