2% difference when calculating Percentage between 2 columms

[ruthgammack]

Hi,

I have the following where i have selected a value from a customer dropdown and then when i select this and calculate the percentage using a measure it is out by 2% everytime. How can i resolve this

Count %  = DIVIDE(DISTINCTCOUNTNOBLANK(Table[Column1]), (DISTINCTCOUNT(Table[Column2]))) *100

So there is (11/63)*100 is 17.46% 

but the Measue is giving 19.23% 

Do i need to include an AllSelected or something as i am using the filter? 

[Fowmy]

@ruthgammack 

Not enough details and context. Try using either DISTINCTCOUNTNOBLANK or DISTINCTCOUNT for both columns.