Display exact value instead of first or last or Count

[maheshchubb123]

Data:

Requirement:

Group API wise and display total success and total failure percentage.

I created the required two measures as follows:

GlobalSuccessPercentage = IF(SUM(GlobalAPIMAPIsUsageDaily[callCountTotal]) == 0, "No Requests" , CONCATENATE(CONVERT
(ROUND(DIVIDE(SUM(GlobalAPIMAPIsUsageDaily[callCountSuccess]),SUM(GlobalAPIMAPIsUsageDaily[callCountTotal])) * 100, 2),STRING), "%"))

Sample output: 88%

GlobalFailurePercentage = IF((GlobalAPIMAPIsUsageDaily[callCountTotal]) == 0, "No Requests" , CONCATENATE(ROUND((DIVIDE(SUM(GlobalAPIMAPIsUsageDaily[callCountFailed])),SUM(GlobalAPIMAPIsUsageDaily[callCountTotal])))*100,2),"%"))

Sample output: 20%

But when i created a card and binded GlobalSuccessPercentage, it is showing below options instead of displaying calculated as it is.

so it either displays first or last or count. so irrespective of API i select it always diplays the same value. Same issue for GlobalFailurePercentage  as well.

Please let me know if iam missing anything here.

[Ashish_Mathur]

Hi,

Based on the data that you have shared, please show the exact result that you are expecting.  Also, share data in a format that can be pasted in an MS Excel file.

[amitchandak · Accepted solution]

@maheshchubb123 , Looking at the first measure seems like you are return text. For percent, you should return the number.

Also, seem like is a measure so already aggregated.

Create only this

DIVIDE(SUM(GlobalAPIMAPIsUsageDaily[callCountSuccess]),SUM(GlobalAPIMAPIsUsageDaily[callCountTotal]))

if you return "no request" it will become text. Then the formula is correct and should work.

In case you use the above formula then from the measure tool, mark it % and choose decimal