Forum Discussion
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 ...
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
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