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 set...
Need Help
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.