Forum Discussion

thomassto14's avatar
thomassto14
Regular Visitor
9 years ago

group by customer and sum value

Hi i create a report with Filled map and when i click the country i want, i have at the right a table with all customers of this country and salesvalue off them. I would like to summarize salesvalue ...
Reports
SabineOussi's avatar
SabineOussi
Icon for Skilled Sharer rankSkilled Sharer
9 years ago

Hi thomassto14

 

Try this measure:

SalesValue = SUMX(VALUES(Table1[Customer]),CALCULATE(SUM(Table1[Sales])))

 

Hope this helps!

  • Yokimi's avatar
    Yokimi
    New Member
    9 years ago

    Hello SabineOussi

    You are my saviour! :catvery-happy:

    Thank you