DAX syntax to calculate the percentage of the total

[ale259]

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.

[Anonymous]

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

[ale259 · Accepted solution]

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 

[bhanu_gautam]

@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)

[ale259]

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