Dax Calculation

[Anonymous]

Hi,

I am having trouble writing the calculation below and keep running into errors.

(SUM [OH TTL U RTL] WHERE [J RETAIL FH FIRST/FURTHER] = "FIRST" OR "FURTHER")*[OH TTL AUC].

[Anonymous]

Thank you that worked for me!

[tamerj1]

Hi @Anonymous 

are you trying to create a measure or a calculated column? 

[Anonymous]

A measure

[tamerj1]

@Anonymous 

Sorry but you mean to say

(SUM [OH TTL U RTL] WHERE [J RETAIL FH FIRST/FURTHER] = "FIRST" OR "FURTHER")*SUM([OH TTL AUC]).

[Anonymous]

I am looking for how to write that in dax.  That is not the calculation I am using.

[tamerj1 · Accepted solution]

@Anonymous 

Not sure if I properly understand the requirement. Is something like:

=
SUMX (
FILTER ( 'Table', 'Table'[J RETAIL FH FIRST/FURTHER] IN { "FIRST", "FURTHER" } ),
[OH TTL U RTL] * [OH TTL AUC]
)