Week by week Defect percentage

[Anu]

Hi,
Please help me calculate percentage:
count of P1 priority (Highest) weekly/ total no of defects raised in that week

what I mean here is, 33 should be divided by 237(which is total of all defects) and so on for all weeks count

[ilze.krauze]

Hi!
Try defining new calculated measure

with following formula and change formatting to the % type you want:

CASE WHEN 
([Priority].DefaultMember, [Measures].[Issues created])>0
THEN
[Measures].[Issues created]
/ ([Priority].DefaultMember, [Measures].[Issues created])
END

More about creating calculated measures can be found here: Calculated measures and members

Kind regards,
Ilze // support@eazyBI.com

[Anu]

Thanks a lot @ilze.krauze. It worked for me.

Regards,
Anu