Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 in group by each customer. How can i do this in PowerBi?
hallellujah!!!!!!!
Hi @thomassto14
Try this measure:
SalesValue = SUMX(VALUES(Table1[Customer]),CALCULATE(SUM(Table1[Sales])))
Hope this helps!
Could you please provide some sample data so that we can provide solution based on your table data?
Best Regards,
Herbert
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |