# Xray Test Pass Percentage

**URL:** <https://community.eazybi.com/t/xray-test-pass-percentage/435>\
**Category:** Questions & Answers\
**Tags:** xray\
**Created:** [March 29, 2018, 5:40pm UTC](https://community.eazybi.com/t/xray-test-pass-percentage/435 "2018-03-29T17:40:11Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![vamakam](https://community.eazybi.com/letter_avatar_proxy/v4/letter/v/c77e96/32.png) [@vamakam](https://community.eazybi.com/u/vamakam)\
**Post date:** [March 29, 2018, 5:40pm UTC](https://community.eazybi.com/t/xray-test-pass-percentage/435/1 "2018-03-29T17:40:11Z")

</div>

Hi,

I would like to get the pass percentage from the overall test cases by project, please suggest how I can achieve.

 ![image](https://community.eazybi.com/uploads/default/original/1X/a312171d9b1a0edcbbad480771176dace6f802dd.png)

---

<div class="post-metadata">

**Author:** ![lauma.cirule](https://community.eazybi.com/user_avatar/community.eazybi.com/lauma.cirule/32/8830_2.png) [@lauma.cirule](https://community.eazybi.com/u/lauma.cirule)\
**Post date:** [April 12, 2018, 12:24pm UTC](https://community.eazybi.com/t/xray-test-pass-percentage/435/2 "2018-04-12T12:24:57Z")

</div>

Hi!

With following formula, you can calculate what part of total tests have passed.

```
CASE WHEN [Xray Test Execution Status].CurrentMember IS [Xray Test Execution Status].DefaultMember
THEN
([Measures].[Xray Tests executed],
 [Xray Test Execution Status].[PASS]) 
/ [Measures].[Xray Tests executed]
END

```

Please make sure you change the formatting of the result to %.

The result will display on the total level of Execution status, see screenshot below

 ![26](https://community.eazybi.com/uploads/default/original/1X/a3376b856b1a3c88966ddbd01f69bfb7b3ad45ad.png)  
Note that some tests might have been failing first, but if they have Passed at some time they will be counted in the Pass and it might give the total 100% as in the screenshot above.

Please let me know if you have further questions regarding this!  
Lauma / [support@eazybi.com](mailto:support@eazybi.com)