Percentage should be calculated on rows

agudipelli · August 14, 2023, 8:00pm

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

roberts.cacus · August 21, 2023, 8:19am

Hi @agudipelli,

Try the calculated measure formula below:

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

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.

Best,
Roberts // support@eazybi.com

agudipelli · August 24, 2023, 9:20pm

Thank You Robert, It Worked Thank You