Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
3 | |
1 | |
1 | |
1 |
User | Count |
---|---|
26 | |
3 | |
2 | |
2 | |
2 |