Forum Discussion
jbbr111
9 years agoNew Member
Dax Filter - Two values in the filter from same column not rendering
YTD New TIV Policy Effective Date := CALCULATE ( SUM ( 'FactPolicyCoverage'[CoverageAmount] ), DATESYTD ( 'PolicyEffectiveDimDay'[PolicyEffectiveDayDate] ), 'DimNewRenewal'[NewRenewal...
- 9 years ago
Change the && to || :smileyhappy:
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! :smileyhappy:
Sean
9 years agoCommunity Champion
Change the && to || :smileyhappy:
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! :smileyhappy: