Forum Discussion
Card display the same total as table
I did what you suggest but it did not work has expected.
As you can see in the image in the table I have count displayed and filter when it is greater that 1, but the measure gives all the count and does not allow me to filter by the aggregation count.
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.
