Forum Discussion

Giada90's avatar
Giada90
Helper IV
2 years ago
Solved

field parameter doesn't aggregate

Hi,

I have a ds like this:

personsalescost
a45
a64
a23
a65

 

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

personsales OR cost
a18 OR 17
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 

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    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.