Forum Discussion

PTSS's avatar
PTSS
Frequent Visitor
3 years ago
Solved

how to add formula from visual matrix

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 ac...
  • v-zhangti's avatar
    3 years ago

    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.