Forum Discussion
Card display the same total as table
Hello
This must be a simple question but I'm not able to do it.
I have a table that as the following values:
ID summary Count(occurences>1)
1 a 3
2 b 2
3 c 2
Total 7
Now, how can I display the total (7) in a card visual?
I tried measure, filter.. and the value was not the same.
Thanks
25 Replies
creat a new measure total_count=count(table[count])
an then drag it to the canvas as a card.
replace the name table with your 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?
What´s display in visual card? What´s number?
Anonymous drag the card visual and put count column or measure in card and keep count in visual level filter as required condition then u can see the output expected
Hi Anonymous,
Please try the solution yoav20007, please share a screenshot for further analysis if there is still an issue.
Best Regards,
AngeliaHello all,
I am also having this same issue, did anybody find a good way around this?
I'm presuming because the card has no link to the ID Summary field, then it can only do a total overall and will ignore the filter for Count(occurences > 1) because of the no link. In my case when i try to filter by count occurences then i always get 1 as a filter result.
Any help would be appreciated, thanks
