DAX Help

[meena16_vibrant]

HI,

a,b,c,d values are presented in same matrix format as below. I want to write a DAX measure for Formula1 and Final Formula. Can you pls let me know how to achieve it in DAX?

[wdx223_Daniel]

say, the field of "Test1","Test2" is F1, and F2 is the field of a,b,c,d

NewMeasure =
IF (
    ISFILTERED ( Table[F1] ),
    IF (
        ISFILTERED ( Table[F2] ),
        BLANK (),
        DIVIDE (
            SUMX ( VALUES ( Table[F2] ), [Val1] * [Val2] ),
            SUMX ( VALUES ( Table[F2] ), [Val1] )
        )
    ),
    SUMX ( SUMMARIZE ( Table, Table[F1], Table[F2] ), [Val1] * [Val2] )
)

[meena16_vibrant]

Thank you so much @wdx223_Daniel .   Can you please help to get DAX for final formula?

(B2*D2)+(B6*D6) .

B2 - sum of value (a +b) and  D2= value which I get from formula1.

B6 -sum of value(c+d) and D6 = value which I get from formula1. I have to show it in card visual.

[wdx223_Daniel · Accepted solution]

when you put this measure in you matrix, the grand total will give the result of (B2*D2)+(B6*D6)