field parameter doesn't aggregate

[Giada90]

Hi,

I have a ds like this:

person	sales	cost
a	4	5
a	6	4
a	2	3
a	6	5

if I make a field paramet

er and I make a table, I can't aggregate.

What I need is something like this:  how can I do? I'm using columns not measures

person	sales OR cost
a	18 OR 17

[v-jtian-msft]

Hello,@amitchandak ,thanks for your concern about this issue.

Your answer is excellent!And I would like to share some additional solutions below.
Hi,@Giada90 .I am glad to help you.

You could try to change the vsiual name:

As @amitchandak suggested,you could also try to create measure:

Creating strings for splicing functions of measure: sales OR cost

sales OR cost = FORMAT([M_cost],"General Number")&" OR "&FORMAT([M_sales],"General Number")

M_cost = SUM('Table'[cost])

M_sales = SUM('Table'[sales])

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

Best Regards,

Carson Jian,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@Giada90 , You have to create measures for Sum of Sales and Sum of Cost. The field parameters on a column will be used for group by ( not summarize) in a visual