calculated cell

[madji]

Hi, everyone

I am new in Power BI

I have table with article

article      value

article1    100

article2    100

article3     10

article4     0

I want to get a column value 1 when I save value for article 1-3 , and calculated for article 4 in Report

article      value1

article1    100

article2    100

article3     10

article4     = 100+100 - 10

How can I get it in Power BI ?

Thanks!

[v-jiascu-msft]

Hi @madji,

Can you mark the proper answer as a solution please?

Best Regards,

Dale

[v-jiascu-msft]

Hi @madji,

If the sample is all you have, you can do it as below. Or it would be complicated.

value1 =
VAR a1 =
    CALCULATE (
        SUM ( Table1[value] ),
        FILTER ( 'Table1', Table1[article] = "article1" )
    )
VAR a2 =
    CALCULATE (
        SUM ( Table1[value] ),
        FILTER ( 'Table1', Table1[article] = "article2" )
    )
VAR a3 =
    CALCULATE (
        SUM ( Table1[value] ),
        FILTER ( 'Table1', Table1[article] = "article3" )
    )
RETURN
    IF ( [article] = "article4", a1 + a2 - a3, [value] )

Best Regards,

Dale