Why match function show the total result too

[ehasnawi98]

so i have a data , example

Company          Total profit

A                            2000

B                           5000

C                            3000

when i use the edit expression , i want to show the total profit of company A and C

so i use =Match(company,'A','C')

but when i generate the piechart , it will show the profit from company A, C and (the total of totalprofit from A,B,C - total profit from A,C)

how to remove the result of(total profit from A,B,C-total profit from A,C)? because i dont even declare it in the expression

[tresB]

Are you using calculated dimension? Try instead measure expression, like:

Sum(If(Match(Company,'A','C'), [Total profit]))