Forum Discussion
Card display the same total as table
Anonymous
do you mean something like this?
measure = calculate( countrows([table]), occurences > 1)
?
More or less, in fact what I need is:
measure = Calculate(Sum(ocurrences), occurences > 1), which in fact is the total displayed in the table.
My data is something like:
id ocurrence target
1 1 1
1 1 2
2 1 3
3 1 4
3 1 5
So my measure should display: 4 (id 1 and 3) and not include id=2 because it has only one occurence.
Anonymous okay good, is that working now?
vanessafvg, it does not work, I can not use the ocurrences > 1 filter in the measure or filter in the report.
Anonymous ok, i am obviously missing something, why not? is that because its derived? grouped by the MRnumber
all the MRnumbers look greater than 1, so you want to know when there is more than one occurence of MRnumber?