Forum Discussion

joshua1990's avatar
joshua1990
Icon for Post Prodigy rankPost Prodigy
2 years ago

% Stacked Bar Chart - Measure always in thousand

Hi experts!

I am just playing aroung with a simple % stacked bar chart and somehow the measure remains to stay in a format for thousand.

Instead of 100% I get 0K%.

I haven't applied any format settings. It is a sample count measure.

 

What is the issue here?

 

Thanks

Need Help

1 Reply

  • Sahir_Maharaj's avatar
    Sahir_Maharaj
    Icon for Super User rankSuper User
    2 years ago

    Hi joshua1990,

     

    A common pattern for a percentage calculation might look something like:

    Percentage Measure = 
DIVIDE(
    COUNT(YourTable[SomeColumn]), 
    CALCULATE(COUNT(YourTable[SomeColumn]), ALL(YourTable)),
    0
)

    Hope this helps.