Forum Discussion

gauravnarchal's avatar
gauravnarchal
Post Prodigy
4 years ago
Solved

Issue with Percentage Total

Dear All   I am using the below measure to get the available limit in percentage. I am getting the desired result but the total percentage is not reflected correctly in the result. It always shows ...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi gauravnarchal ,

    You can create a another new measure as below to get the correct total percentage, then put this new measure onto the table visual to replace the measure [Available Limit]. Please find the attachment for the details.

    Measure = SUMX(VALUES('ClientMaster'[ProfileNameGroup]),[AvailableLimit])

    Best Regards

gauravnarchal's avatar
gauravnarchal
Post Prodigy
4 years ago

AlexanderPrime  - If I remove "0" it does not show any value in the total.

 

Also, Balance Remaining and Credit Limit both are set as decimal numbers.

 

 

AlexanderPrime's avatar
AlexanderPrime
Solution Supplier
4 years ago

Does doing it like in the below image work? (May need forum admins to approve attached image if not showing, if it doesn't load. try using: 

AvailableLimit = DIVIDE(SUM('Table'[BalanceRemaining]),(SUM('Table'[CreditLimit])))    Replacing 'Table' with the respective table name.)



Is this going into a matrix? Or a visual for each indiviual record. Need a bit more context of what you are trying to do with it if the below doesn't work. 

  • gauravnarchal's avatar
    gauravnarchal
    Post Prodigy
    4 years ago

    AlexanderPrime   - Now I am getting the value but the percentage total is showing incorrect.

     

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi gauravnarchal ,

      You can create another new measure as follows and apply it to your visual to replace your existing measure [Available Limit].  

      Measure = SUMX ( VALUES ( 'Tablename'[categorycolumnonvisual] ), [Available Limit] )

      Besides that, you can refer the methods in the following videos to resolve your problem:

      Why Your Total Is Incorrect In Power BI - The Key DAX Concept To Understand

      Dax for Power BI: Fixing Incorrect Measure Totals

      If the above ones can't help you, please provide some raw data from your model tables with Text format, visual setting&display(Fields pane) with screenshots and your expected result. Thank you.

      Best Regards

      • gauravnarchal's avatar
        gauravnarchal
        Post Prodigy
        4 years ago

        Anonymous  - Please find attached the PBIX for your reference. Thank you for looking into this.

         

        PBIX  - Click Here