Forum Discussion

madji's avatar
madji
Helper I
8 years ago

calculated cell

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!

Need Help

2 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    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] )

    calculated_cell

     

    Best Regards,

    Dale