Forum Discussion
Calculate Percentage
HI, Below is the data:
We are getting incorrect values in visualization as its calculating average of all rows for the month
Expected result:
currently we are using the formaula:
%TTR = Total Met SLA/Closed Incident SLA
please suggest how we can group data on month level. can we apply the formula at visualization level.
I am willing to be that because you do not have aggregates in your formula that you implemented this as a calculated column? Which means that you must be doing some weird sum or average in your visual? If you implement your formula as a measure it will work correctly, I checked.
Measure 4 = SUM(Incidents[Total Met SLA])/SUM(Incidents[Total Closed])
For future reference, please post your sample data in something that can be copied and pasted. Makes it way easier than manually typing it in by hand from an image.
4 Replies
I am willing to be that because you do not have aggregates in your formula that you implemented this as a calculated column? Which means that you must be doing some weird sum or average in your visual? If you implement your formula as a measure it will work correctly, I checked.
Measure 4 = SUM(Incidents[Total Met SLA])/SUM(Incidents[Total Closed])
For future reference, please post your sample data in something that can be copied and pasted. Makes it way easier than manually typing it in by hand from an image.
HI,
Thankyou for the response. I am not able to create a measure for the above formula. The data is from a Summarized table from another dataset. and Total Met SLA in the formula is also a calculated column. i think thats the reason i am not able to create a measure.
Is it possible to post you raw data from which you created the summarized table. And share the link.
Cheers
CheenuSing
