topic in measures in DAX Commands and Tips

in measures

Anonymous — Wed, 09 Nov 2022 04:11:32 GMT

fgf

Re: in measures

Anonymous — Tue, 08 Nov 2022 16:11:43 GMT

hello Anonymous ,
please try:

Measure = VAR selected = SELECTEDVALUE(Table1[Nationality ]) return IF( selected <> "Italy" && MAX(Table1[Years]) < 3,SUM(Table1[Salary])/24,IF(selected <> "Italy",SUM(Table1[Salary])/12,0))

Re: in measures

tamerj1 — Tue, 08 Nov 2022 16:34:20 GMT

Hi Anonymous
Hope attached file satisfies your requirement

Insurance = SUMX ( FILTER ( 'Table', 'Table'[Nationality ] = "Non-Italy" ), IF ( 'Table'[Years] < 3, 'Table'[Salary] / 24, 'Table'[Salary] / 12 ) )