Forum Discussion

GoingIncognito's avatar
GoingIncognito
Icon for Advocate III rankAdvocate III
6 years ago
Solved

Filter one table to only include values that have equaling values in two columns

My question is fairly simple: On a report page all I need to display is a table. And this table receives all the rows from database table as is. Only one filter needs to be used: Table[Date1] = Tabl...
Need Help
  • Mariusz's avatar
    Mariusz
    6 years ago

    Hi GoingIncognito 

     

    You can use the below as a measure 

    Measure = SUMX( 'Table', INT( 'Table'[x] = 'Table'[y] ) )

     And use the Measure to filter Visual table like.

     

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn

     

Mariusz's avatar
Mariusz
Icon for Community Champion rankCommunity Champion
6 years ago

Hi GoingIncognito 

 

You can use the below as a measure 

Measure = SUMX( 'Table', INT( 'Table'[x] = 'Table'[y] ) )

 And use the Measure to filter Visual table like.

 

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

 

GoingIncognito's avatar
GoingIncognito
Icon for Advocate III rankAdvocate III
6 years ago

Yass, thank you! Your solution is of the outmost absolute brilliance, thank you!