Dax Function

[Rocky_Brown]

I ned a measure that searches a field for multiple  sets of characters.  I have tried both the Contains and Search and cannot seem to get the measure to work.

I have tried:

Measure = IF(OR(CONTAINS('Data','Data'[Category],"GP"),CONTAINS('Data','Data'[Category],"Other Value")), DIVIDE([Current Year Actual],[Current Year Budget]))

and 

Measure = CALCULATE(SUM('No Charge'[QtyShipped]),SEARCH("Door",'No Charge'[Item Class],,0)>0,SEARCH("Model",'No Charge'[Item Class],,0)>0),

Please help

Thanks

[v-xulin-mstf]

Hi @Rocky_Brown

Is your issue solved?

If the issue has been solved, please adopt the solution to help others.

If you still have some question, please don't hesitate to let me known.‌‌

Best Regards,

Link

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

[v-xulin-mstf]

Hi @Rocky_Brown,

Your formula looks fine.

Could you provide your sample data and expected output?

Sample data and expected output would help tremendously.

Best Regards,

Link

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

[parry2k]

@Rocky_Brown Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490