Create a calculated row

[marcelodiashms]

Hi friends,

I need to create a calculated row called "Faturamento líquido" where faturamento bruto minus (-) impostos sobre faturamento to columns Previsto and Real. It's possible?

[v-gizhi-msft · Accepted solution]

Hi,

According to your description, I create sample data below:

Please follow these steps:

1)Create a table like this:

And append it to categoria1 table like this:

2)After ‘Close&Apply’, create two measures to display the original table you provide:

Here are my measures:

Previsto = SUM(Table2[Previsto])

Real = SUM(Table2[Real])

3)Create two measures to calculate minus result to [Previsto] and [Real]:

Previsto-Minus

= FIXED(CALCULATE(Table1[Previsto],FILTER(ALLSELECTED('Table1'),Table1[id1]=1))-CALCULATE(Table1[Previsto],FILTER(ALLSELECTED('Table1'),Table1[id1]=2)),2)

Real-Minus

= FIXED(CALCULATE(Table1[Real],FILTER(ALLSELECTED('Table1'),Table1[id1]=1))- CALCULATE(Table1[Real],FILTER(ALLSELECTED('Table1'),Table1[id1]=2)),2)

4)Create two measures to display the result:

Previsto-Result

= IF(MAX(Table1[id1])=4 && HASONEVALUE('Table1'[id1]),[Previsto-Minus],[Previsto])

Real-Result

= IF(MAX(Table1[id1])=4 && HASONEVALUE('Table1'[id1]),[Real-Minus],[Real])

5)The result shows:

Here is my test pbix file.

pbix 

Best Regards,

Giotto Zhi

[marcelodiashms]

Hi,

Amazing! Thanks for your solution! 😉