cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
GraceTCL
Helper II
Helper II

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!

 

Disconnected.PNG

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

  

4 REPLIES 4
v-deddai1-msft
Community Support
Community Support

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

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!

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

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.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Top Solution Authors
Top Kudoed Authors