Forum Discussion
Amount Spent on Modifiers
Morning, I'm trying to calculate the amount of money spent on specific modifiers in my dataset. I've attached my pbix so it's a bit easier to work with: My Pbix For each transaction there are...
tester = CALCULATE (
COUNT( 'itemdetailsdogfood$'[Modifiers Applied] ), FILTER('itemdetailsdogfood$', 'itemdetailsdogfood$'[Modifiers Applied] = "bacon" || 'itemdetailsdogfood$'[Modifiers Applied] = "bacon,*"),How would I be able to do that and simply count any occurence of bacon regardless of if it's by itself or accompanied by "onion, bacon, cabbage" for example.
I tried using the * and that didn't help lols; I had a look at the search function, but I wasn't sure how I could apply that.
Thoughts?