In the above data I have shown only one Case Dimension Sequence ID. But a Business User will have multiple Case Dimesion Sequence ID.
In my dashboard I have Business User as a dimension and in measure I need to show the sum of the networkdays between the Minimum TaskStart Date and a date selected in filter based on the following conditions.
In the variable vEndDate I am putting the date selected in filter.
So, if I select 10/17/2017 as the date in the filter, in the above example only the first row satisfies all the conditions and I should have the output as Networkdays('10/03/2017,'10/17/2017') which is 11. So the output will be like
But I am getting the value of the measure as 143.
When I calculate the measure for all the rows and columns in the data above I am getting the following.
So, basically the set expression gets applied and the result appears as 0 for all the rows which do not satisfy the conditions. But for the row which satisfies the conditions the network days of all the rows get summed up and appears in that row.
Can anyone please let me know how to resolve this issue.