Forum Discussion
2% difference when calculating Percentage between 2 columms
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?
1 Reply
ruthgammack
Not enough details and context. Try using either DISTINCTCOUNTNOBLANK or DISTINCTCOUNT for both columns.
