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 ...
Need Help
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