Hide rows where all measures do not contain data

• 

  Kristoffer Drejer

  October 11, 2021 08:34

  Try a visibility agent with the following formula

  count(all,0,all) = 0 

  0
• 

  Karoline Johansen

  October 11, 2021 08:48

  It does not work as intended, unfortunately. 

  The table should be a top/bottom table and this is working fine when I have not inserted the budget measure, but only the actual measure. The problem occurs when I insert my budget measure, because some customers have a budget, but no actual numbers. So, I would like to hide all customers with budget and no actual numbers, so I am able to make a rank and then hide all customers not in the top or bottom. 

  0
• 

  Kristoffer Drejer

  October 11, 2021 08:51

  Aah that changes thing then, you wrote where all measures don't contain data. But as you write now, it sounds like m2 is the budget, and m1 might be empty as no sales has occured.  

  Then give this a try:

  count(all,0,m1) = 0 

  0
• 

  Karoline Johansen

  October 11, 2021 08:57

  Sorry my mistake, I see that my formulation wasn't correct.

  Now it is working - thanks for your help! :)

  0

Please sign in to leave a comment.