I have a dataset with values like below
ABCD Theatre 1 100ABCE Theatre 2 300ABCE Theatre 4 200ABCD Theatre 3 150GABC Theatre 1 120PLK Theatre 2 100ABCE Theatre 5 125
I need to create a measure with sum of ticketcharge where movie name contains ABC with output ABC-1075Need help for this.
I treid like belowMEASURE = SUMX('MOVIETABLE',FILTER('MOVIETABLE','MOVIETABLE'['Movie'] = 'ABC'),TicketCharge)
Go to Solution.
You can create a measure below:
View solution in original post
If you need at the start
MEASURE = SUMX('MOVIETABLE',FILTER('MOVIETABLE',left('MOVIETABLE'['Movie'],3) = "ABC"),TicketCharge)
Anywhere in the string
MEASURE = SUMX('MOVIETABLE',FILTER('MOVIETABLE',search("ABC",'MOVIETABLE'['Movie'],1,0)>0 ),TicketCharge)
Proud to be a Super User!
SumABC = CALCULATE(SUM('Table'[TicketCharge]),FILTER('Table',FIND("ABC", 'Table'[Movie],,0)<>0))
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.