Forum Discussion
Creating measure by adding column value
Hi All, I have a dataset with values like below ABCD Theatre 1 100 ABCE Theatre 2 300 ABCE Theatre 4 200 ABCD Theatre 3 150 GABC Theatre 1 120 PLK Theatre 2 100 ABCE Theatre 5 125 Mo...
Hi Anonymous,
You can create a measure below:
Measure = SUMX(FILTER(ALL('Table'),SEARCH("ABC",'Table'[Movie],1,0)>0),'Table'[TicketCharge])Best Regards,
Qiuyun YuAnonymous
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)
SumABC = CALCULATE(SUM('Table'[TicketCharge]),FILTER('Table',FIND("ABC", 'Table'[Movie],,0)<>0))
SumABC = CALCULATE(SUM('Table'[TicketCharge]),FILTER('Table',FIND("ABC", 'Table'[Movie],,0)<>0))
Thanks shameeralikvqa