Forum Discussion

N2Coffee's avatar
N2Coffee
Frequent Visitor
8 years ago
Solved

Filter Frustration

Production Line	Order	Batch	Time	Status
1	100	a	6/1/2018 13:00	Running
1	100	b	6/1/2018 14:00	Ready
2	120	d	6/2/2018 4:00	Not Ready
2	130	e	6/2/2018 4:15	Not Ready
3	150	f	6/1/2018 11:00	Ready
3	175	g	6/1/2018 11:29	Ready

First, accept my thanks to all of those who post and reply...I find both helpful as I try to get a handle on DAX and PBI.

Second, I have searched the postings before writing.

Third, Thanks in advance for your assistance.

Fourth, apologies for wasting your time with this list!

 

I am creating a dashboard for maunfacturing, not sales; my data is framed by the hour, rather than the normal weekly, monthly, etc..

 

The data I want to display are only those production lines whose first (earliest) Time status is "Not Ready" and the time expected to start, So, for the tabel below, I would only want to see the row with Batch d.

 

Thanks in advance 

 

Production LineOrderBatchTimeStatus
1100a6/1/2018 13:00Running
1100b6/1/2018 14:00Ready
2120d6/2/2018 4:00Not Ready
2130e6/2/2018 4:15Not Ready
3150f6/1/2018 11:00Ready
3175g6/1/2018 11:29Not Ready
  • N2Coffee's avatar
    N2Coffee
    8 years ago
    Daniel
    Sorry for the delayed response...busy with family and friends during the holiday week.
    Your solution solution works!!! I added 2 other fields that I needed to see with additional CONCATENATEX statements. I will post those when I get back home.

    I really appreciate your help...I never thought of using CONCATENATEX as an iterator for this measure.


    Thanks again- I hope to return the favor someday

4 Replies

  • v-danhe-msft's avatar
    v-danhe-msft
    Microsoft Employee
    8 years ago

    Hi N2Coffee,

    Based on my test, you can refer to below steps:

    1.I have entered some sample data to test for your problem in below picture.

    2.Create a new measure to filter your status.

    Show data=var t=FILTER('Row table','Row table'[Status]="Not Ready" && 'Row table'[Time]=CALCULATE(MIN('Row table'[Time]),ALLEXCEPT('Row table','Row table'[Production Line])))

    return

    CONCATENATEX(t,[Batch],",")

     

    3.Create a Card visual and add the [show data] fileld.

     

     

     

    You can also download the PBIX file to have a view.

    https://www.dropbox.com/s/iiwto05006p36zu/Filter%20Frustration.pbix?dl=0

     

    Regards,

    Daniel He

     

     

    • N2Coffee's avatar
      N2Coffee
      Frequent Visitor
      8 years ago
      Daniel
      Thanks for your help. I have limited access to the internet but wanted to thank you for your reply to my posting. It looks like this will work; I’ll let you know when I try it out.
      • v-danhe-msft's avatar
        v-danhe-msft
        Microsoft Employee
        8 years ago

        Hi N2Coffee,

        I am appreciate it if you could tell me your problem has been solved. If it is, could you please mark the helpful reply as Answered?

         

         

        Regards,

        Daniel He