10 Replies Latest reply on Oct 24, 2016 10:39 PM by Nikunj Bhardava

    How to use a formula to know if I choose all of one dimension?

    baron li

      I have two questions here --


      Question 1

      I have one dimension about region (A, B , C D)


      How can I build a calculated filed to know if I choose all of them then measure A

      If I only choose one of them -- then measure B


      Question 2

      Question B is due to my LOD for market share


      There are region, segment, year data here -- ideally I want to build a dashboard in which market share can be calculated automatically when I choose different region, segment.


      My current problem is when I filter to region.


      SUM([Headcount])/MIN({ FIXED[Overseas Domestic Value], [Core Segment],[Commencing Value], [Year1]:SUM([Headcount])})


      The formula above hasn't taken region into consideration -- It works only for the total country level.


      When I add 'region' into Fixed formula -- it works for each region separately but not for the total country level -- because some brands are not available in some regions -- then the fixed formula while deduct these regions for these brands