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