Forum Discussion

ALEX13's avatar
ALEX13
Icon for Helper I rankHelper I
8 years ago
Solved

Delete or not count values from a table when the value is in another table

Hi, community, I am in need of some help with this problem:   I have two tables, one for Ok orders, and another for not Ok orders:   Table1 (NOK orders): IC Client Order 1000002806 1383...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    Hi ALEX13

     

    Create a relationship betweeen above tables using IC Client

     

    Then we can use this calculated Table

     

    Table =
FILTER ( NOK_orders, ISBLANK ( RELATED ( OK_orders[Order] ) ) )
ChandeepChhabra's avatar
ChandeepChhabra
Icon for Impactful Individual rankImpactful Individual
8 years ago

Hi ALEX13

 

How do you wish to see the result?

Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago

Hi ALEX13

 

Create a relationship betweeen above tables using IC Client

 

Then we can use this calculated Table

 

Table =
FILTER ( NOK_orders, ISBLANK ( RELATED ( OK_orders[Order] ) ) )