Calculate Percentage

[Paridhisharma]

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.

[Greg_Deckler · Accepted solution]

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.

[Paridhisharma]

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. 

[v-ljerr-msft]

Hi @Paridhisharma,

It's better to share a sample pbix file(with just some sample/mock data) which can reproduce the issue. So that we can better assist on this issue. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading. 

Regards

[Anonymous]

Hi @Paridhisharma

Is it possible to post you raw data from which you created the summarized table.  And share the link.

Cheers

CheenuSing