Forum Discussion

jbbr111's avatar
jbbr111
New Member
9 years ago
Solved

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...
  • Sean's avatar
    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: