Chi Square Test in DAX - Getting wrong p-values

A chi2 test can test 2 things:

1) distribution goodness-of-fit and

2) whether 2 categorical variables are independent.

What are you trying to achieve here? I can't see any relevance of what you're doing to the above.

Here's an excerpt from When to Use a Chi-Square Test (With Examples) - Statology: