Create Slicer based off of Already Sliced Values for Unique Count (Min/Max)

[broman5000]

Hi there,

I'm stumped...

I have 5 slicers that are slicing by (Location, Year Month, Day Date, Order Method and Service Method)

I then have a bunch of visuals that are based off of those slicers

I have a map created that goes by lat/long and is based off of the unique counts of latitude to look at how many times that location ordered something based off of the slicer criteria (By location, dates, methods and ect)

Problem now is, that I would like to slice between the (min of that count - max of that count) - case below would be between 1-7...kicker is that those counts change whenenever you use the 5 slicers that i spoke of above

I tried inserting another slicer and I can't make it based off of the values that the 5 slicers found as a min-max count

I feel like i have to write something in dax or create a new table to find the variable min/max...ugh i'm stumped...any help would be appreciated!

LatitudeNumber	LongitudeNumber	Count of OrderNumber
25.938001	-80.212676	7
25.979125	-80.2194305	6
25.9678244	-80.1952612	5
25.9473582	-80.224267	4
25.960768	-80.194917	4
25.9619327	-80.1890946	4
25.9385065	-80.2083619	3
25.9449906	-80.2109331	3
25.9532451	-80.2062483	3
25.9543107	-80.1815611	3
25.9482849	-80.2082748	1
25.9487656	-80.2048738	1
25.9487667	-80.2008757	1
25.9489163	-80.2169031	1
25.9497012	-80.1917783	1
25.9500862	-80.1854603	1

[v-jiascu-msft · Accepted solution]

Hi @broman5000,

That's because the values from a measure which needs context. There could be two solutions.

1. Add a new column like below. Since it becomes a column, you can add it in a slicer easily. There could be many duplicates.

column =
CALCULATE (
    COUNTROWS ( 'table' ),
    ALLEXCEPT ( 'table', 'table'[LatitudeNumber], 'table'[LongitudeNumber] )
)

2. Create a measure and add it in the Visual Level Filter. 

Best Regards,

Dale

[v-jiascu-msft · Accepted solution]

Hi @broman5000,

Could you please tell me if you get the answer or the solution?

Best Regards,

Dale

[v-jiascu-msft · Accepted solution]

Hi @broman5000,

That's because the values from a measure which needs context. There could be two solutions.

1. Add a new column like below. Since it becomes a column, you can add it in a slicer easily. There could be many duplicates.

column =
CALCULATE (
    COUNTROWS ( 'table' ),
    ALLEXCEPT ( 'table', 'table'[LatitudeNumber], 'table'[LongitudeNumber] )
)

2. Create a measure and add it in the Visual Level Filter. 

Best Regards,

Dale

[broman5000]

Hi there,

I'm stumped...

I have 5 slicers that are slicing by (Location, Year Month, Day Date, Order Method and Service Method)

I then have a bunch of visuals that are based off of those slicers

I have a map created that goes by lat/long and is based off of the unique counts of latitude to look at how many times that location ordered something based off of the slicer criteria (By location, dates, methods and ect)

Problem now is, that I would like to slice between the (min of that count - max of that count) - case below would be between 1-7...kicker is that those counts change whenenever you use the 5 slicers that i spoke of above

I tried inserting another slicer and I can't make it based off of the values that the 5 slicers found as a min-max count

I feel like i have to write something in dax or create a new table to find the variable min/max...ugh i'm stumped...any help would be appreciated!

LatitudeNumber	LongitudeNumber	Count of OrderNumber
25.938001	-80.212676	7
25.979125	-80.2194305	6
25.9678244	-80.1952612	5
25.9473582	-80.224267	4
25.960768	-80.194917	4
25.9619327	-80.1890946	4
25.9385065	-80.2083619	3
25.9449906	-80.2109331	3
25.9532451	-80.2062483	3
25.9543107	-80.1815611	3
25.9482849	-80.2082748	1
25.9487656	-80.2048738	1
25.9487667	-80.2008757	1
25.9489163	-80.2169031	1
25.9497012	-80.1917783	1
25.9500862	-80.1854603	1