Hello
I hope you are fine
I have a question about Easy BI
I want to find the number of values in each row in a report, but no matter how I use the count function, I can’t succeed.
I want to count the total number of people whose names are in the Assignee column every day according to the photo sent.
Thank you for helping me
Hi @Alireza
Welcome to the eazyBI community!
You may want to create a calculated measure that retrieves the number of assignees (except (unassigned)) with transitions during that day:
Sum(
Filter(
Generate(
VisibleRowsSet(),
[Assignee].CurrentHierarchyMember
),
[Assignee].CurrentMember.Name <> "(unassigned)"),
case when ([Measures].[Transitions to assignee]+[Measures].[Transitions from assignee])>0
then 1
end
)
Function VisibleRowsSet() is used here; how to apply it in calculations you may watch a presentation by my colleague Jānis Plūme: Training videos on specific topics
Use this measure in the report columns.
Additionally, to avoid showing assignees without transitions (what might happen when this new measure is added in the report), create one more measure for filtering the list: it would count total transitions (to and from the status) for each assignee on that day:
[Measures].[Transitions to assignee]+[Measures].[Transitions from assignee]
Add this measure in columns and set a filter >0 on it; then remove it.
The final report would look the following:
Best
IlzeLA, support@eazybi.com