Count the Over all Data, Success and Failure in Column Chart

Hi,Anonymous .I am glad to help you.

Like this?
I calculate the number of Failure,Success,Abandoned calls per day for all data and I also calculate the total number of calls per day.

On the right is the percentage of each type of calls to the total number of calls recorded per day.

 

 

DIVIDE([DailyCallsKinds],[DailyCallsAll],0) 

 

 

 

I noticed that there are call records with a status of BLANK in the test data you gave. If this is present in your data, then calculating the total number of calls per day is necessary. (Check if there are records with status =blank)

This is the measures I create:

 

 

M_totalAll = COUNTROWS('WT Usage Table')


M_TotalFailure = CALCULATE(COUNTROWS('WT Usage Table'),FILTER('WT Usage Table','WT Usage Table'[ClientCallStatus] = "FAILURE"))


M_TotalSuccess = CALCULATE(COUNTROWS('WT Usage Table'),FILTER('WT Usage Table','WT Usage Table'[ClientCallStatus] = "SUCCESS"))


M_TotalAbandoned = CALCULATE(COUNTROWS('WT Usage Table'),FILTER('WT Usage Table','WT Usage Table'[ClientCallStatus]= "ABANDONED"))

 

 

Measures to calculate the percentage:

 

 

M_TotalFailurePercent = DIVIDE([M_TotalFailure],[M_totalAll],0) 


M_TotalSuccessPercent = DIVIDE([M_TotalSuccess] ,[M_totalAll],0)


M_TotalAbandonedPercent = DIVIDE([M_TotalAbandoned],[M_totalAll],0) 

 

 

If you want to show the specific values of the data in visual, I recommend you to turn on the following options to make it easier for you to analyse the data.

I hope my suggestions can bring you help. If there is any error in my understanding, please correct me promptly and provide more detailed data and expected results (including the establishment of relationships between tables in the model, judgement logic of calculations, etc.).
If possible, please provide a test file of pbix that does not contain sensitive data and share it on the forum via github link. This will help to solve your problem.

The Data Model relationship.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.