Forum Discussion

Vizbaby's avatar
Vizbaby
Helper I
1 year ago
Solved

Percentage Total is not accurate

The percentage column for my viz is not adding up correctly.  I have used the formulas below but i keep getting same result. The first two columns are the likely correct result but total is  not cor...
Need Help
  • SundarRaj's avatar
    SundarRaj
    1 year ago

    Hey Vizbaby ,
    I'll attach a file link below. Please have a look at the DAX Code and Data Model to see the fundamental of getting the totals. Let me know in case of any queries. Thanks

    Regards,

SundarRaj's avatar
SundarRaj
Super User
1 year ago

Is it possible for you to share the data that you're working with or any dummy data in the same format?

Vizbaby's avatar
Vizbaby
Helper I
1 year ago

The columns in yellow is what im using to calc the rate 

 

 

  • SundarRaj's avatar
    SundarRaj
    Super User
    1 year ago

    Hey Vizbaby ,
    I'll attach a file link below. Please have a look at the DAX Code and Data Model to see the fundamental of getting the totals. Let me know in case of any queries. Thanks

    Regards,