How do we perform a calculation to get a percentage of overall total points that we get?

Questions & Answers
,
1

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:

EazyBI
EazyBI837Ă—552 27.6 KB

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%

2

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

3

Yes, and it’s working.
Thank You

1 Like