Forum Discussion

GraceTCL's avatar
GraceTCL
Icon for Helper II rankHelper II
5 years ago

Disconnected slicer isnt working

Hi,

 

I am trying to create an output where based on the selection of "NetInflowRange", the respective count of Merchants falling within the range will populate. The other dimension (highlighted in yellow) in the matrix output is variable and I presume it can work based on the relationships of the table.

 

Here is an idea of the expected output but the formula in tab "Qn3" isnt working. Reference formula below too. Hope someone can advise who to make this output work. Thanks!

 

Here is a sample file: https://www.dropbox.com/scl/fi/rsoy72ni9hwdf99verz3o/exemplify.xlsx?dl=0&rlkey=a1m22k2cif4ej8shlimihqtnt

 

Formula used:

MexOulets within NetInflowRange = 
CALCULATE([MexBrandsWithSale],
    FILTER('d_merchant',[Net Inflow %GMV] >= [Selected Inflow%_Low] &&
        [Net Inflow %GMV] < [Selected Inflow%_Low]))

where

Selected Inflow%_High = MAX('Net Inflow Range'[Low])
Selected Inflow%_Low = min('Net Inflow Range'[Low])

  

Need Help

4 Replies

  • v-deddai1-msft's avatar
    v-deddai1-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi GraceTCL ,

     

    Really can't understand your expected output based on your sample data and description. Would you please explain more about your expected output? 

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    Best Regards,

    Dedmon Dai

    • GraceTCL's avatar
      GraceTCL
      Icon for Helper II rankHelper II
      5 years ago

      Hi v-deddai1-msft ,

       

      I am expecting the count of merchants to be reflected based on the segment (between low and high segmented inflow) that is selected. At the same time, because I will be pulling another dimension eg vertical or category, the count of merchants will be reflected against this other dimension as per table in earlier message. Hope this clarifies!

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Icon for Super User rankSuper User
        5 years ago

        Hi,

        I think i can solve this, but I do not see any semblence between the data that you have shared in the screenshots of your original post and the excel file that you have uploaded.  Share a small datasset and on that small sample dataset, show the expected result.