Issue with Percentage Total

[gauravnarchal]

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 0%.

Measure

AvailableLimit = DIVIDE([BalanceRemaining],[CreditLimit],0)

[AlexanderPrime]

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? 

[gauravnarchal]

@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]

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]

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

[Anonymous]

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]

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

PBIX  - Click Here

[Anonymous · Accepted solution]

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