DAX measure include specific filter

HI Anonymous ,

 

Can you share your measure please?

 

Thanks,

Pragati

Hi Anonymous 

 

You could try a measure like 

Cost New =
CALCULATE (
    [Cost],
    'tablename'[Clarity Project Created Date] >= DATE ( 2016, 1, 1 ),
    'tablename'[HW/SW] = "Hardware",
    'tablename'[Part Category] IN { "SHW", "SSW" },
    'tablename'[Part TotalQuantity] >= 1,
    CONTAINSSTRING ( 'tablename'[Project Location], "PSS" )
)

Or

Cost New =
CALCULATE (
    [Cost],
    FILTER (
        'tablename',
        'tablename'[Clarity Project Created Date] >= DATE ( 2016, 1, 1 )
            && 'tablename'[HW/SW] = "Hardware"
            && ( 'tablename'[Part Category] IN { "SHW", "SSW" } )
            && 'tablename'[Part TotalQuantity] >= 1
            && CONTAINSSTRING ( 'tablename'[Project Location], "PSS" )
    )
)

Note that CONTAINSSTRING is not case-sensitive. If you want it to be case-sensitive, use CONTAINSSTRINGEXACT instead. 

 

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.