Reply
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Create a measure shows all the Regions in a single column having same Sales in same Country
01-25-2023
01:43 AM
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.
1 ACCEPTED SOLUTION
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-25-2023
02:44 AM
1 REPLY 1
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-25-2023
02:44 AM

I'v solved by my self. Anyway thank you everyone.

Helpful resources
Recommendations
Subject | Author | Posted | |
---|---|---|---|
02-19-2024 12:19 PM | |||
03-07-2024 03:51 AM | |||
01-03-2024 11:22 AM | |||
06-21-2023 02:10 PM | |||
01-10-2023 04:11 PM |
Featured Topics
Top Kudoed Authors (Last Month)
User | Count |
---|---|
138 | |
107 | |
84 | |
60 | |
46 |