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

Hi Vizbaby,

To get the Percentages in the measure as the final total:

What you could do over here is create a Variable of a Summarised Table with the Percentage Column as against the Vendor Job.

 

Use IF and HasOneFilter function to replace the total value with Sum of the Percentage Column in the summarized table. This is a very high level picture of it. Let me know if you need a granular view. Thanks

 

Regards,

  • Vizbaby's avatar
    Vizbaby
    Helper I
    1 year ago

    Please can u give me granular level? i have the formulas i tried on my post. 

    • 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