Forum Discussion

meena16_vibrant's avatar
meena16_vibrant
Frequent Visitor
3 years ago
Solved

DAX Help

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's avatar
    wdx223_Daniel
    3 years ago

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

3 Replies

  • wdx223_Daniel's avatar
    wdx223_Daniel
    Community Champion
    3 years ago

    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's avatar
      meena16_vibrant
      Frequent Visitor
      3 years ago

      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's avatar
        wdx223_Daniel
        Community Champion
        3 years ago

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