Percentage should be calculated on rows

Hi All,

I am trying to find a calculated definition to calculate the percentage of status,
I have attached the screenshot

I am trying to calculate the percentage based on the custom filed/ component against the status.

When I try to do the calculate percentage its taking columns as consideration but not rows,
How do the get the rest as shown in image 1.

Thank You

Hi @agudipelli,

Try the calculated measure formula below:

CASE WHEN ([Measures].[Issues created],[Status].DefaultMember) > 0
[Measures].[Issues created]
([Measures].[Issues created],[Status].DefaultMember)

The report could look similar to the one below:

Please look at our documentation page for more information on defining calculated measures - ​Calculated measures and members.

Roberts //

Thank You Robert, It Worked Thank You

1 Like