topic Re: Dax Calculation in DAX Commands and Tips

Dax Calculation

Anonymous — Tue, 22 Nov 2022 18:11:16 GMT

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

tamerj1 — Tue, 22 Nov 2022 18:32:40 GMT

Hi Anonymous

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

Anonymous — Tue, 22 Nov 2022 18:36:44 GMT

A measure

tamerj1 — Tue, 22 Nov 2022 19:09:13 GMT

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 — Tue, 22 Nov 2022 19:11:39 GMT

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

tamerj1 — Tue, 22 Nov 2022 19:24:23 GMT

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 — Tue, 22 Nov 2022 20:01:03 GMT

Thank you that worked for me!