cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## 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?

Super User

@ruthgammack

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

Did I answer your question? Mark my post as a solution! and hit thumbs up

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.