Creating SLA Report

[Anonymous]

Hi All,

I'm a biginner in PowerBI and I'm working on transitioning Excel SLA reports to PowerBI and here I would need help to calculate average for each priority tickets which is added in seperate sheets.

I used to calculate average of Achieved and Breached tickets using this calcualtion in Excel : =IFERROR(COUNTIF('Restore P1'!$G:$G,"Achieved")/(COUNTIF('Restore P1'!$G:$G,"Achieved")+COUNTIF('Restore P1'!$G:$G,"Breached")),"N/A") 

Please find below snapshot of Excel report, I'm looking for same thing to create in powerBI .

Thanks

Ameer

[v-lid-msft]

Hi  @Anonymous ,

Does this problem have been resolved?Could you please provide more details about it If it still not be resolved? It seems the screenshot you shared does not been available. Please don't contain any Confidential Information or Real data in your reply.

Best regards,

[v-lid-msft]

Hi @Anonymous ,

Sorry for that, We cannot understand your data model clearly, Could you please provide a mockup sample based on fake data or describle the fields of each tables and the relations between tables simply? It will be helpful if you can show us the exact expected result based on the tables. Please upload your files to OneDrive For Business and share the link here.

Best regards,

[Greg_Deckler]

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490