topic Re: DAX syntax to calculate the percentage of the total in DAX Commands and Tips

DAX syntax to calculate the percentage of the total

ale259 — Wed, 12 Feb 2025 21:27:52 GMT

Hello,
I created the calculate DAX as the picture below, and the result is everyday 100%, which 100% should be the total of the whole week.

Can anyone point out what's wrong with my code? Thank you.

Re: DAX syntax to calculate the percentage of the total

bhanu_gautam — Thu, 13 Feb 2025 03:38:47 GMT

ale259 Try using

DAX
PercentOfAllVisitors =
VAR TotalSumVisitors = SUM('Daily Visits 2024'[SumofVisitors])
VAR GrandTotalVisitors = CALCULATE(SUM('Daily Visits 2024'[SumofVisitors]), ALL('Daily Visits 2024'))
RETURN DIVIDE(TotalSumVisitors, GrandTotalVisitors)

Re: DAX syntax to calculate the percentage of the total

Anonymous — Thu, 13 Feb 2025 03:59:50 GMT

Hi ale259 ,

Thanks for bhanu_gautam's reply!
The information you provided is too little. It is unlikely that we can accurately identify the problem based on the existing information.
After testing, there should be no problem with the DAX you provided (if you only have one table):

The problem should be in your data model or in your measure [SumofVisitors]. Please provide sample data of all the data tables involved, the relationship between the tables, and the DAX used by measure [SumofVisitors] (you can replace your actual data with the test data). Thank you!

Best Regards,
Dino Tao

Re: DAX syntax to calculate the percentage of the total

ale259 — Thu, 13 Feb 2025 14:06:58 GMT

Hi Dino, thank you for your response. It seems that I cannot upload PowerBI up here, so I wonder how to share this file.

Anyhow, this is my relationship tables:

Sum of Visitors = SUM('Daily Visits 2024'[Visitors]

I also create other measures (in total I have 28 measures), such as the Year-over-year that I created after this measure of percentage of total with this syntax:

YoY% Visitors =

VAR Visitors2024 = [SumofVisitors]

VAR Visitors2023 = SUM('Daily Visits 2023'[Visitors])

return DIVIDE(Visitors2024 - Visitors2023, Visitors2023)

I wonder if my measure Percentage of Total is not working because of this Year-over-year measure that is created afterwards. Thank you

Re: DAX syntax to calculate the percentage of the total

ale259 — Thu, 13 Feb 2025 14:07:32 GMT

Yes I used that and it's now working. Tu.