Forum Discussion

andyspa's avatar
andyspa
Helper I
5 years ago
Solved

Market share in Map Visualization

Hello everybody,   I have the following data.   I want to create a Map in Power BI to show on a first level the country, then the town. Legend must show the players and the balls size the indisti...
Need Help
  • v-alq-msft's avatar
    v-alq-msft
    5 years ago

    Hi, andyspa 

     

    You may try the following measure to see if it helps. 

    Measure = 
DIVIDE(
    SUM('Table'[Market Share]),
    CALCULATE(
        SUM('Table'[Market Share]),
        ALLEXCEPT('Table','Table'[Country])
    )
)

     

    Result:

     

    Best Regards

    Allan

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

andyspa's avatar
andyspa
Helper I
5 years ago

Hello v-alq-msft ,

 

I want to show the real market share when moving the cursor to the pie slice, not 1830%! Cannot be more than 100%.

 

Thanks.

Andrea

v-alq-msft's avatar
v-alq-msft
Community Support
5 years ago

Hi, andyspa 

 

You may try the following measure to see if it helps. 

Measure = 
DIVIDE(
    SUM('Table'[Market Share]),
    CALCULATE(
        SUM('Table'[Market Share]),
        ALLEXCEPT('Table','Table'[Country])
    )
)

 

Result:

 

Best Regards

Allan

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.