Calculate percent columns by several tables

Hi,ND1979 
Thank you for your prompt response.

I’m pleased to see that you are using the DAX query view for testing; it’s indeed a good method of validation. However, please note that the results returned in the query view are presented as a table, whereas the code I provided is context-based.

Here are the results I obtained in the table view on my desktop:

And here are the results from the DAX query view:

For further details, please refer to:

Deep dive into DAX query view and writing DAX queries | Microsoft Power BI Blog | Microsoft Power BI
DAX query view - Power BI | Microsoft Learn

Given the similarity to your erroneous results, I recommend creating a new calculated column.

Even if you don’t use it later, you can easily delete it by right-clicking.

Moreover, calculated tables and columns, including measures, do not affect the original data. They are not visible in Power Query, which serves as the best evidence of this. Therefore, you need not worry about creating unnecessary DAX expressions impacting your future work.

I hope my response is clear enough to help you understand the reasons behind the issue.If you have any further questions, feel free to ask!

Best Regards,

Leroy Lu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.