Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
scabral
Helper IV
Helper 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

0 REPLIES 0

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.