topic Re: DAX Help in DAX Commands and Tips

DAX Help

meena16_vibrant — Fri, 27 Jan 2023 06:22:03 GMT

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?

Re: DAX Help

wdx223_Daniel — Fri, 27 Jan 2023 07:13:54 GMT

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] ) )

Re: DAX Help

meena16_vibrant — Sun, 29 Jan 2023 08:58:36 GMT

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.

Re: DAX Help

wdx223_Daniel — Mon, 30 Jan 2023 03:39:16 GMT

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