Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
14 | |
4 | |
2 | |
1 | |
1 |
User | Count |
---|---|
22 | |
3 | |
3 | |
2 | |
2 |