The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
13 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
14 | |
12 | |
3 | |
2 | |
2 |