Calculating percentage of the bin

[xariet]

Hi All,

will appreciate it if somebody points out the error in my calculation. I need to calculate the % of each bin. My calculation is giving me 100% per bin.

% of bin = [Number of borrowere]/ CALCULATE([Number of borrowere], FILTER(ALL(Sheet1),  Sheet1[LTV ratio (bins)]=SELECTEDVALUE(Sheet1[LTV ratio (bins)])))

where

Number of borrowere = DISTINCTCOUNT(Sheet1[Borrower ID Number])

LTV ratio (bins) is a calculated column

[amitchandak · Accepted solution]

@xariet , for % of total you should try like

% of bin = divide([Number of borrowere], CALCULATE([Number of borrowere], allselected()))

or

% of bin = divide([Number of borrowere], CALCULATE([Number of borrowere], all()))