Suppose there is a points measure and collective sum of all the points is 20, then based upon the sum there we should get a value of 5%.

Example:

Total points = 10+8+5+4+3+5 = 35

There should be another measure name Percentage:

If sum of points > 25 = 5%

If sum of points >10 & <= 15 = 4%

If sum of points >0 & <= 10 = 3%

as here the sum of points = 48

So, percentage should be 5%

Hi @Chaitanya_Kulkarni

I believe you also contacted the eazyBI support directly. I will paste the solution here too, in case other eazyBI users are looking to create similar reports.

The below measure will create a new column with a percentage depending on the sum of the measure â€śPointsâ€ť. To return the percentage, the percentage formatting should be selected (Calculated measures)

```
CASE WHEN [Issue].CurrentHierarchyMember.Name = '$total_aggregate'
THEN
CASE
WHEN
Sum(VisiblerowsSet(),[Measures].[Points]) > 25
THEN
0.05
WHEN
Sum(VisiblerowsSet(),[Measures].[Points])>10 AND
Sum(VisiblerowsSet(),[Measures].[Points]) <= 15
THEN
0.04
WHEN
Sum(VisiblerowsSet(),[Measures].[Points])>0 AND
Sum(VisiblerowsSet(),[Measures].[Points])<= 10
THEN
0.03
END
END
```

Best wishes,

Elita from support@eazybi.com

Yes, and itâ€™s working.

Thank You

1 Like