getselectcount issue

[jinxiaolin1]

hi handsome I want to show the default value such as 2019 sales when no fields selected and dynamic value when some fields selected, so i use if ,but how to express no fields selected? looking forward for your reply, thank you.

[Kashyap_R]

Hi 

Try this

If(GetselectedCount([Year])=1,Sum(Value),Sum({<[Year]={2011}>}Value))

Hope it helps

Thanks

[tresesco]

GetSelectedCount() works on single field, here you would need a function that works on any/all fields. Try using GetCurrentSelections(), like:

If(Len(GetCurrentSelections())>0,Sum(Value),Sum({<[Year]={2019}>}Value))