Forum Discussion
Post ProdigyIssue 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
Solution SupplierThat 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?
Post ProdigyAlexanderPrime - 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
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
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