topic Dax in DAX Commands and Tips

Dax

MSAYED26 — Thu, 21 Sep 2023 09:16:14 GMT

I want to write a Dax measure to calculate (measure1 /2) if name =A or B, (measure2 /5) if name =C or D or E,(measure3 /7) if name =F or G

Thanks,,,,

ChiragGarg2512 — Thu, 21 Sep 2023 10:20:17 GMT

1) Create a measure that changes with the selection in the filter. Ex. measure4 = values(name)

2.1) create another measure using switch statement. measure5 = switch(measure4, "A", [measure 1]/2, "B", [measure 1]/2, .......).

It can also be done with IF statement.

2.2) It can also be done with IF statement.

Measure 5 = IF([Measure4] IN{"A", "B"}, [Measure 1] /2, IF([Measure4] IN{"C", "D", "E"}, [measure 2]/5, [measure 3]/7))

MSAYED26 — Thu, 21 Sep 2023 10:19:35 GMT

I mean measure1/2 it divide measure1 / 2

ChiragGarg2512 — Thu, 21 Sep 2023 10:23:03 GMT

Divide the measures OR divide measure1 by measure2

Also the previous response has been edited, see if that works.