Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hey Experts,
I am having an issues while creating a formula for Aggregation(Sum or Subtraction) on Record level on a Single dimension column.
my data is like in the below format for your referance.
Country | Sales |
India | $150 |
Australia | $200 |
America | $500 |
China | $750 |
Japan | $620 |
Now i need to get aggregation on Sales of India+America and China-Japan.
Please Help me on this.
TIA,
Habib Shaik.
Solved! Go to Solution.
@Anonymous
you can try formula like below
Proud to be a Super User!
Hi Habib,
I would suggest you create some groups of the countries. Then it's easy to get "sum of" and to show them in the visual. Please refer to the snapshot below.
Best Regards,
Dale
@Anonymous
you can try formula like below
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
78 | |
64 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |