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
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
Anonymous - Please find attached the PBIX for your reference. Thank you for looking into this.
PBIX - Click Here
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