Forum Discussion
Card display the same total as table
Hi,
what´s difference between MR Number and Total Count? Is it both measures?
No they are not the same. One is a column of my data source (MR number) , which in fact is count of a column. The other is a measure as suggested by yoav20007
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?
