'Question Resolving a Dax Query in Power Bi
I´m a bit new to Power Query and would love some help with achieving the requirements for a certain dashboard.
I have a Requests Table where I have the attributes:
| RequestId | Continent | Country | Another header |
|---|---|---|---|
| 1 | Europe | Spain | Madrid |
| 2 | Europe | Spain | Madrid |
| 3 | Europe | France | Paris |
| 4 | Europe | France | Paris |
| 5 | Europe | Spain | Valencia |
| 6 | America | USA | Madrid |
I would like to have a ring chart with only the top 2 'places' that have made requests, where 'places' are the concatenantion of Continent | Country | City. For this small example the ring chart would have 2 (count of) requests for Europe | Spain | Madrid, and 2 (count of) requests for Europe | France | Paris. The data import mode is made by DirectQuery.
Thank you.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|