2% difference when calculating Percentage between 2 columms

ruthgammack — Sat, 09 Dec 2023 15:11:00 GMT

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?

Re: 2% difference when calculating Percentage between 2 columms

Fowmy — Sat, 09 Dec 2023 16:03:06 GMT

ruthgammack

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

topic Re: 2% difference when calculating Percentage between 2 columms in DAX Commands and Tips

2% difference when calculating Percentage between 2 columms

Re: 2% difference when calculating Percentage between 2 columms