Forum Discussion

angelikakolacz's avatar
angelikakolacz
Icon for Helper I rankHelper I
4 years ago

Search with multiple criteria

Hello, I have a table with more than milion rows with data from different customers. I’m looking for a dax formule that gives me the following result (see column output):   ACCOUNT NUMBER INVO...
angelikakolacz's avatar
angelikakolacz
Icon for Helper I rankHelper I
4 years ago

Hi Jihwan_Kim ,

 

Can you explain how i can share a link with you? I cann't add a file..

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
4 years ago

HI,

Thank you for your message.

Instead of attaching a file, please try share the link of your pbix file.

Onedrive link, googledrive link, dropbox link, or any other link....

Thanks.

    • Jihwan_Kim's avatar
      Jihwan_Kim
      Icon for Super User rankSuper User
      4 years ago

      Hi,

      As seen in the below picture, some of them shows two invoice numbers. which invoice number do you want to select and show? Or, do you want to show two invoice numbers if there are two?

       

       

      • angelikakolacz's avatar
        angelikakolacz
        Icon for Helper I rankHelper I
        4 years ago

        Hi Jihwan_Kim 

         

        Thank you for your answer. I want to see one unique value as output. 
        So if the output is multiple output, i only want to see one unique value. If this one is already used as output i want to see another one (if there is another one).

         

        Like this example: 

        so as output i want to see one value by row. see this example: 
        i have crossed out the unnecessary ones