I am using set actions to move members from an Include worksheet to an Exclude worksheet and vice versa. When the Exclude worksheet has no rows (OUT = zero members), I would like DZV to hide its container on the dashboard.
I tried FIXED LODs and Table Calcs, but I don't think they work when you are using set actions to add/remove members from the set (as opposed to dimension filters). See attached
I think this violates the rule about DZV visibility being control by something dependent on the worksheet, but I thought I would see if anyone had a workaround for it. Thanks.
Thank you in advance for your help.
Dave
{ FIXED: COUNT(IF NOT [Set] THEN [Anything] END) = 0 }
having the =0 inside the braces is important. It won’t work if you put it outside. There shouldn’t be any limitation caused by using Set actions. A calculation has no visibility of how a set was populated.
DZV calculations must be at the level of the workbook. You can’t use anything from a worksheet, because the same field could have two different values on two worksheets in a dashboard.
