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 ...
  • 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
v-danhe-msft's avatar
v-danhe-msft
Icon for Microsoft Employee rankMicrosoft 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
      Icon for Microsoft Employee rankMicrosoft 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

      • N2Coffee's avatar
        N2Coffee
        Frequent Visitor
        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