Forum Discussion
Dax Calculation
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
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]
)
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]).
I am looking for how to write that in dax. That is not the calculation I am using.
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]
)