Forum Discussion

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

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.

how to add formula from visual matrix.pbix38 KB

v-zhangti

Community Support

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.

how to add formula from visual matrix.pbix38 KB