Forum Discussion
Solved
range measure
Data table look like this account amount date axxxx 123 2017/1/1 axxxx 323 2018/2/1 bxxx 133 201712/1 bxxx 432 2018/2/3 cxxx...
Hi martylin,
You can create a calculate column to stored range tag, then use it to create table visual with 'account column' as summary mode count.
Category = VAR _count = COUNTAX ( FILTER ( ALL ( table ), [account] = EARLIER ( table[account] ) ), [account] ) RETURN IF ( _count > 0, IF ( _count <= 2, "0-2", IF ( _count <= 4, "3-4", IF ( _count >= 5, "5↑" ) ) ) )Regards,
Xiaoxin Sheng
