Forum Discussion

paulj1's avatar
paulj1
Icon for Helper II rankHelper II
5 years ago

Slicer not Showing correct Entries (USERELATIONSHIP measure issue)

I have an annoying issue that I need help with...🤔

 

So I have a model with deliveries by date and supplier and reference, these are then collated into production batches.

 

I have a calendar table that is linked to the Production date, with an inactive link back to delivery date.

 

Want a report, with a single relative date filter, two tables that operate on that date filter to show in that date range for deliveries, and production.  No problem, as I can use a measue with USERELATIONSHIP to operate using the inactive date relation ship, all good. 

 

I hit a problem when I want a slicer on that report page by supplier, what the slicer is asking, show me the deliveries by that supplier on the current deliveries table.  But the date filter is filtering the slicer items, the suppliers in the table are not the same as in the slicer.

 

Note, I've made up an example file, in the real file I have 10 years of deliveries, and 1000+ suppliers, so cannot edit relationships to turn off the date filter, as the slicer would have 1000+ entries.  Slicer needs to show the suppliers with deliveries in that date range

 

Sample file link below, and images...

 

Many thanks for help.  Have a good weekend when it come to you

 

Stay safe and well

 

Paul

 

 

https://1drv.ms/u/s!ApcyZzyFx2-9hZRgrJD__Iw1U1MC2w?e=6M25WN

 

 

 

3 Replies

  • paulj1 , this model will not work, you have to merge delivery and Del2batch and create one table and merge  Production and del2batch create another table.

     

    join between Del2batch  and delivery /Production  need to avoided

     

    • paulj1's avatar
      paulj1
      Icon for Helper II rankHelper II

      amitchandak Cant do that a single delivery can be split of multiple production batches......  mmmm....

  • Anyone got any thoughts.....  A workaround i arrived at was to duplicate suppliers list along with date of last delivery, then i filter it by 6 months, so at least i have a slicer with all suppliers in the last 6 months, this report is mainly used for looking at recent past so that is a messy work around.