Forum Discussion

RingoSun's avatar
RingoSun
Helper II
4 years ago
Solved

100% stack bar percentage calculation

I need help to match the 100% stack bar percentage value with my measure percentage value In my visual above, the 100% stack bar percentage value is 17.25% but my measure percentage calculatio...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    Hi, 

    If 17.25% is what you want to show, please change the measure [FloorShareTota%] like below.

     

    FloorShareTotal% =
    DIVIDE ( [FloorShareTotal], CALCULATE ( [FloorShareTotal], ALL ( dimBrand ) ) )

RingoSun's avatar
RingoSun
Helper II
4 years ago

Jihwan_Kim 

Oh that worked! But I tried it with my real data and it didn't seem to work 😞

 

 

Both must be 15.71% but my measure calculation is showing 2.60%. Although when I try to filter to REFRIGERATOR category then it shows me the correct percentage.

 

FloorShareTotal% = DIVIDE (
    [FloorShareTotal],
    CALCULATE ([FloorShareTotal], ALLSELECTED(dimSkuSos)
))

 

dimSkuSos basically contains the column which I used as the legend for my stacked bar chart 

 

I cant share my pbix with the real data but I hope you could give me some insight with what I have provided.

 

Thank you so much!

Jihwan_Kim's avatar
Jihwan_Kim
Super User
4 years ago

Hi,

I cannot understand by only seeing the screenshot. What I can suggest for now is, please try to use ALL function instead of ALLSELECTED.