I have a straight table chart, in which I am using a complicated expression to show the dimension.
The problem is that when I click on a row, the same is not selected, while it should be.
I am attaching an example to demo this issue. I think it is a bug. Thank you for any inputs.
I know it works without the calculated dimension but the purpose is to make this work with a calculated dimension. That is the functionality of the dashboard. 🙂
I had kept a simple calculation with 'If condition', only to put my question across. I have a lengthier calculated dimension in my dashboard that I cannot get rid of. This looks like a bug.
Any other thing that comes to you mind?
You should be able to open this now. Its not a personal edition file.
If you still arent, I have a calculated expression that goes like
Tha is not a bug. The behavior is natural for your data. if you remove 'Always One Selected Value' from radiobutton field, it would work. If you keep one value selected and try to select a single value from Customer, that would not work because for any selection in radiobutton all possible combination of customers are associated. So the scope of selection is contradictory there.
Hope this gives you an idea.
Thank you Jagan. This works brilliantly. Adding an Aggr() in the start of the calculated dimension solved it.
Do you think it might cause any performance concerns?
Thank you Tresesco. That made complete sense. And it started working for me when I unchecked the 'Always One Selected Value' option. But I wonder, how is Jagan's solution above (which I have marked correct) working just fine?
Any thoughts would be helpful.