Forum Discussion
scabral
8 years agoHelper IV
How to perform OR in Filter using DAX
Hi,
I have the following DAX query using a filter:
EVALUATE
(
FILTER
(
FILTER
(
ADDCOLUMNS
(
SUMMARIZE
(
'FE Values',
'ProspectClient'[AcctNo],
'FE Loc'[Index Rec No],
'FE Values'[BIM/PVE Variance % (Owned)],
'FE Values'[BIM/FE Variance % (Owned)],
'FE Values'[FE PD (Owned)],
'FE Values'[FE Value],
'FE Values'[FE PD],
--'FE'[FE TE],
'FE Loc'[FE Engrg Name],
'FE Loc'[Address Line 1],
'FE Loc'[City],
'FE Loc'[State],
'FE Loc'[Country],
'FE Loc'[Division],
'FE Loc'[Occupancy/SubOcc Cd (Predominant)],
'FE Loc'[Occupancy (Predominant)],
'FE Values'[PVE Analyzed %],
'FE Values'[BIM Bldg (sq ft)],
'FE Values'[PVE Bldg (sq ft)],
'FE Values'[BIM/PVE Change Contents %],
'FE Values'[BIM Stock (sq ft)],
'FE Values'[PVE Stock (sq ft)],
'FE Values'[BIM/PVE Change Stock %],
'FE Values'[Total Area],
'FE Date'[Year],
'FE Loc'[FE Insurer Status]
),
"BIM PD (Owned)", calculate(sum('FE Values'[BIM PD (Owned)])),
"PVE PD (Owned)", calculate(sum('FE Values'[PVE PD (Owned)])),
"BIM-Value", calculate(sum('FE Values'[BIM-Value])),
"PVE PD", calculate(sum('FE Values'[PVE PD])),
"PVE Bldg", calculate(sum('FE Values'[PVE Bldg])),
"PVE Contents", calculate(sum('FE Values'[PVE Contents])),
"PVE Stock", calculate(sum('FE Values'[PVE Stock]))
),
'ProspectClient'[AcctNo] = "00043"
),
'FE Loc'[FE Insurer Status] = "Active"
)
)
However, in teh Filter for the 'fe Loc'[FE Insurer Status] Field, i want to do an or like this:
'FE Loc'[FE Insurer Status] = "Active" OR 'FE Loc'[FE Insurer Status] = "Prospect"
but i can't seem to find the right syntax. Is ther a way to accomplish this?
Scott
No RepliesBe the first to reply