Possible to create a filter using a measure?

[cdawidow]

I have my product oines (PRD PC) and their cumulative totals which are further grouped by Spend Rank. 

If Cumulative Totals <=60%, High, <=<80%,Vital and <=100%, Low.  I want to be able to filter out these product lines base don their spend rank is there a way to do so without creating a calculated column?

[Greg_Deckler]

@cdawidow - You can use grouping/binning in DAX or you could create a measure for that similar to:

Measure = 
  SWITCH(TRUE(),
    [Cumulative Sales %]<=.6,"Group 1",
    [Cumulative Sales %]<=.8,"Group 2",
    "Group 3"
  )

Might need a column, not clear from your post what you are trying to end up with exactly. 

[cdawidow]

Hey Greg, thanks for that but what I am trying to achieve is shown below ( this is from a calculated column)

It however does not work for me as I need to filter out the various product lines based on selected customers.  When I use a filter and select a customer name, the values do not change.  That is why I would like to create the same as above but in the form of a measure. 

[Greg_Deckler]

@cdawidow - You should be able to use a Disconnected Table for that. In general, to use a measure in that way, you need to use the Disconnected Table Trick as this article demonstrates: https://community.powerbi.com/t5/Community-Blog/Solving-Attendance-with-the-Disconnected-Table-Trick...

[amitchandak]

@cdawidow , to create filter on measure you need to create an independent table and have the values there.

Now you have to create a new measure where this measure can filter / fit in bucket /value of that independent table

Refer example

https://www.daxpatterns.com/dynamic-segmentation/
https://radacad.com/grouping-and-binning-step-towards-better-data-visualization
https://radacad.com/dynamic-banding-or-grouping-in-power-bi-using-dax-measures-choose-the-size-of-bi...
https://www.credera.com/blog/technology-solutions/creating-aging-report-using-a-user-selected-date-i...