Forum Discussion

Giada90's avatar
Giada90
Icon for Helper IV rankHelper IV
2 years ago
Solved

field parameter doesn't aggregate

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 l...
Need Help
  • amitchandak's avatar
    amitchandak
    2 years ago

    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 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.