Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Movie | Theatre | TicketCharge |
ABCD | Theatre 1 | 100 |
ABCE | Theatre 2 | 300 |
ABCE | Theatre 3 | 200 |
ABCD | Theatre 4 | 150 |
GABC | Theatre 3 | 120 |
PLKE | Theatre 4 | 100 |
ABCE | Theatre 5 | 125 |
I need to create a measure with sum of ticketcharge where movie name contains ABC with output ABC-1075
Need help for this.
I treid like below
MEASURE = SUMX('MOVIETABLE',FILTER('MOVIETABLE','MOVIETABLE'['Movie'] = 'ABC'),TicketCharge)
giving errors.
Solved! Go to Solution.
Hi @Anonymous,
You can create a measure below:
@Anonymous
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))
@Anonymous
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)
Hi @Anonymous,
You can create a measure below:
SumABC = CALCULATE(SUM('Table'[TicketCharge]),FILTER('Table',FIND("ABC", 'Table'[Movie],,0)<>0))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |