Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I'm trying to create a measure, which shows all the Regions in a single column having same Sales in Same country.
My table:
Country | Region | Sales |
Ukriane | V | 100 |
USA | Z | 100 |
USA | X | 91 |
USA | W | 91 |
China | F | 82 |
China | G | 82 |
China | I | 82 |
Ukriane | A | 65 |
China | J | 50 |
Brazil | C | 23 |
Result I want:
SUM(Sales) | Country | Required Measure |
100 | Ukriane | V |
100 | USA | Z |
91 | USA | X,W |
82 | China | F,G,I |
65 | Ukriane | A |
50 | China | J |
23 | Brazil | C |
Please help me to write DAX.
Solved! Go to Solution.
I'v solved by my self. Anyway thank you everyone.
I'v solved by my self. Anyway thank you everyone.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
88 | |
73 | |
54 | |
43 | |
37 |
User | Count |
---|---|
98 | |
64 | |
54 | |
48 | |
45 |