Forum Discussion

Paridhisharma's avatar
Paridhisharma
Frequent Visitor
8 years ago
Solved

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 usin...
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    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.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

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's avatar
Paridhisharma
Frequent Visitor
8 years ago

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. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi Paridhisharma

     

     

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

     

    Cheers

     

    CheenuSing

     

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee
    8 years ago

    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. :smileyhappy:

     

    Regards