I want to calculate the Billability per employee in a chart view. To make it possible I have define a column [Billability] and assign the type it to Number.
I Make a simple slice in which I have I make a custom expression i.e. [Billability]>=0.
For Calculating Billability per I make a virtual column in my table and create a expression i.e.
SUM(SELECT(RMG[Billabilty], [Employee Name]=[_THISROW].[Employee Name]))
If I create a chart view Billability Matrix then data is showing correctly.
Now for TOP 5 and Bottom 5 Filter condition
I create 2 action button in in which I have created expressions
For Top 5:- LINKTOFILTEREDVIEW("Billability Matrix", IN([ID], TOP(ORDERBY(BillabilitySlice[ID], [Billability Per Employee], True),5)))
For Bottom 5:-LINKTOFILTEREDVIEW("Billability Matrix", IN([ID], TOP(ORDERBY(BillabilitySlice[ID], [Billability Per Employee], FALSE),5)))
Now If I click Top 5 Button it is only showing the top 2 employees not the rest three
Please correct me what I'm doing wrong.
Please Help @Suvrutt_Gurjar, @TeeSee1
I don't see anything wrong. If your Bottom expression works, the Top should also work.
What type of chart are you using?
Does it work in a table view?
Thank You Sir for your response, Problem is resolved
If you share what caused your issue, it might benefit others.
User | Count |
---|---|
35 | |
30 | |
30 | |
20 | |
18 |