March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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!
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
115 | |
76 | |
57 | |
52 | |
44 |
User | Count |
---|---|
164 | |
116 | |
63 | |
57 | |
50 |