Forum Discussion
Dax Function
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
3 Replies
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/38490Hi 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!
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!
