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.

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

Hi, andyspa 

 

It seems correct from the visual. Could you please show us the expected result for better understand?

 

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.