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.

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