Forum Discussion
Issue with Percentage Total
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
That 0 on the end is the "alternative result if error when dividing by 0" result. Which would return 0%, this indicates there may be a problem with it dividing Balance Remaining and Credit Limit, are they both set as whole/decimal number? What happens if you remove the ,0?
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.
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.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