Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
YTD New TIV Policy Effective Date :=
CALCULATE (
    SUM ( 'FactPolicyCoverage'[CoverageAmount] ),
    DATESYTD ( 'PolicyEffectiveDimDay'[PolicyEffectiveDayDate] ),
    'DimNewRenewal'[NewRenewalStatus] = "New",
    FILTER (
        'DimCoverageLimit',
        'DimCoverageLimit'[CoverageLimitDescriptionName]
            = "Building & Business Personal Property Limit"
            && 'DimCoverageLimit'[CoverageLimitDescriptionName] = "Business Income Limit"
    )
)
Trying to filter a column with more then one value being filtered - tried using calculatetable and Filter
If I eliminate one of the values in the filter or in the calculatetable it works - it does not work with two
what am I dong wrong
New to Dax
Thanks for any help
Solved! Go to Solution.
Change the && to || 
YTD New TIV Policy Effective Date :=
CALCULATE (
    SUM ( 'FactPolicyCoverage'[CoverageAmount] ),
    DATESYTD ( 'PolicyEffectiveDimDay'[PolicyEffectiveDayDate] ),
    'DimNewRenewal'[NewRenewalStatus] = "New",
    FILTER (
        'DimCoverageLimit',
        'DimCoverageLimit'[CoverageLimitDescriptionName]
            = "Building & Business Personal Property Limit"
            || 'DimCoverageLimit'[CoverageLimitDescriptionName] = "Business Income Limit"
    )
)Its the same column it can't have both values at the same time but it can be either OR
Hope this helps! 
Change the && to || 
YTD New TIV Policy Effective Date :=
CALCULATE (
    SUM ( 'FactPolicyCoverage'[CoverageAmount] ),
    DATESYTD ( 'PolicyEffectiveDimDay'[PolicyEffectiveDayDate] ),
    'DimNewRenewal'[NewRenewalStatus] = "New",
    FILTER (
        'DimCoverageLimit',
        'DimCoverageLimit'[CoverageLimitDescriptionName]
            = "Building & Business Personal Property Limit"
            || 'DimCoverageLimit'[CoverageLimitDescriptionName] = "Business Income Limit"
    )
)Its the same column it can't have both values at the same time but it can be either OR
Hope this helps! 
 
					
				
				
			
		
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
 
            | User | Count | 
|---|---|
| 87 | |
| 49 | |
| 36 | |
| 31 | |
| 30 |