how to add formula from visual matrix

[PTSS]

currently I have a data concept like this that I insert in the power bi matrix

Rows
Project

Account

Column

Date

Value
AMount

i want to change the amount from the rain/day account to a formula
fill in the formula  Factor Slippery*Total Hujan

what kind of formula should I use, please help

[v-zhangti · Accepted solution]

Hi, @PTSS 

I restored some data and hope it matches your situation.

Sample data:

Measure =
VAR _N1 =SUM ( 'Table'[Amount] )
VAR _N2 =
    CALCULATE (SUM ( 'Table'[Amount] ),
        FILTER (ALL ( 'Table' ),
            [Account] = "Factor Slippery"
                && [Date] = SELECTEDVALUE ( 'Table'[Date] )))
VAR _N3 =
    CALCULATE (SUM ( 'Table'[Amount] ),
        FILTER (ALL ( 'Table' ),
            [Account] = "Total Hujan"
                && [Date] = SELECTEDVALUE ( 'Table'[Date] )))
RETURN
    IF ( _N1 = BLANK (), _N2 * _N3, _N1 )

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PTSS]

Hi @v-zhangti 

Please help me.
I want to add formula in capex = slippery/100. how to if add 2 conditions in amount?

[PTSS]

amazing solution...

but can you help me again, how do you do it if the capex account value is not the same as slippery because the capex value is also 0.
and I want to add a formula in capex from slippery/100

thankyou