Forum Discussion

tosho9's avatar
tosho9
Frequent Visitor
4 years ago
Solved

Help with multiple value search (array or table) with direct query

Hello,    I struggle to find the correct solution for my problem:   I have two direct query tables. Table 1 contains search terms, Table 2 contains the fields to be searched: Search tems tabl...
Need Help
  • v-janeyg-msft's avatar
    v-janeyg-msft
    4 years ago

    Hi, tosho9 

     

    I don't know this function can't be used in DQ column, but you can try to use measure to display results in table visual.

    Like this:

    Measure 2 = CALCULATE (
        MAX(  'Table'[Search tems table] ),
        FILTER (
            ALL ( 'Table' ),
            CONTAINSSTRING (max('Table (2)'[Table 2]), [Search tems table])
              
        )
    )

     

    Best Regards,
    Community Support Team _ Janey

BMH's avatar
BMH
Regular Visitor
4 years ago

The column inventory value is calculate by the sum of Cost price an Quantity. But the sum in the buttom is not correct for the coulumn. How can I get it right ?