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! Request now
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.