Creating a claculated row

[Anonymous]

Hi team,

Below is the sample data ,how to show the calculated row column by using the below syntax.

Attributes	Period1	Period2	Period3	Total
ab	100	100	200	400
bc	100	100	200	400
cd	100	100	200	400
de	100	100	200	400
ef	100	100	200	400
fg	100	100	200	400
gh	100	100	200	400
hi	100	100	200	400
ij	100	100	200	400
jk	100	100	200	400
Result	700	700	1400	2800

Result = ab+bc+cd-de-ef+fg+gh+hi-ij+jk

Regards,

Suresh Pantra.

[parry2k · Accepted solution]

@Anonymous what is the logic? Why you highlight some values in red?

[zoloturu · Accepted solution]

Hi @Anonymous ,

1) Is all table you show a DAX calculated table? If yes, then your question is easy achievable. 

2) Or you put data to the table/matrix visual and need to add an extra row with specific logic? If yes, then it is not working in such way.

Regards,
Ruslan Zolotukhin (zoloturu)
BI Engineer at Akvelon Inc. / Kharkiv Power BI User Group Leader / DAX & Power BI Trainer
-------------------------------------------------------------------
Did I answer your question? Mark my post as a solution!
It was useful? Press Thumbs Up!

You are from Ukraine? If yes then welcome to Power BI User Group - KhPUG website. Other country? Check and find proper one - Power BI User Groups

[zoloturu · Accepted solution]

Hi @Anonymous ,

1) Is all table you show a DAX calculated table? If yes, then your question is easy achievable. 

2) Or you put data to the table/matrix visual and need to add an extra row with specific logic? If yes, then it is not working in such way.

Regards,
Ruslan Zolotukhin (zoloturu)
BI Engineer at Akvelon Inc. / Kharkiv Power BI User Group Leader / DAX & Power BI Trainer
-------------------------------------------------------------------
Did I answer your question? Mark my post as a solution!
It was useful? Press Thumbs Up!

You are from Ukraine? If yes then welcome to Power BI User Group - KhPUG website. Other country? Check and find proper one - Power BI User Groups

[parry2k · Accepted solution]

@Anonymous what is the logic? Why you highlight some values in red?

[Anonymous]

Hi  @parry2k ,

Thank you for your reply.

Substarct the highlited values and rest need to add.

Logic is need to add a row based on the attributes.

For example, i have 4attributes and in that i need to add 3attributes and substarct 1 attribute and need to show the data in new column.

Regards,

Suresh Pantra.

[parry2k · Accepted solution]

@Anonymous so always red one will get extracted?

[Anonymous]

Yes