Disconnected slicer isnt working

[GraceTCL]

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=a1m22k2cif4ej8shlimih...

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])

[v-deddai1-msft]

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]

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!

[v-deddai1-msft]

Hi @GraceTCL ,

Sorry, I still can't understand your issue.  >> Here is an idea of the expected output but the formula in tab "Qn3" isnt working. 

What did qn3 mean? If can understand your request, I may be able to give you a solution. Unfortunately, I can't even relate your formula to the sample data you gave us.

Best Regards,

Dedmon Dai

[Ashish_Mathur]

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.