Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Create a slicer or filter from a Measure

I am trying to create a slicer or filter for a measure   My source data only has a "Billing Start date" and no "Billing Finish Date" we only have the term of contract i.e. 12, 24, 36, etc   I hav...
Need Help
  • v-xiaotang's avatar
    v-xiaotang
    5 years ago

    Hi Anonymous 

    Based on your explanation, I create a sample file, you can take it for reference. See sample file attached below.

    Besides, the easiest way is to create a column,

    In Range Col = IF('All Bookings'[Billing Finish Date]<=TODAY(),"Expired","Booked")

    Then, drag this column into the slicer:

    Result:

    Best Regards,

    Community Support Team _ Tang

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

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , You have to create an independent table(NewTable) with these two values

 

Create measures using this

countx(filter(values(Bookings[Contract#]), [In Range] =max(NewTable[Value])),Bookings[Contract#])

 

Check my video on a similar topic

Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k

Anonymous's avatar
Anonymous
Not applicable
5 years ago

When I try to create the new measure suggested with the new table name I get lots of errors

 

 

Any help will be appreciated