Filtering a table by a measure

[RossBateman]

Hello

I have two tables included in a visual and what I need it to show is any invoices in one table that are not in the other. I created a measure to subtract the toal in one table by the total in the other and just need to filter to exclude any rows where the total of that measure is zero but cant seem to work it out. Any help would be appreciated, I'll add a screenshot below.

[Anonymous]

Hi  @RossBateman  ,

This is my scenario:

Here are the steps you can follow：

1. Create calculated column.

flag =
IF('Table'[Measure]=0,1,0)

2. Place Flag in Filter, select Flag is = 0, app filter

3. Result：

You can downloaded PBIX file from here.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Jihwan_Kim]

Hi, @RossBateman 

Please try to use the function, EXCEPT in your DAX measure.

For instance,

EXCEPT (table1, table2) -> the result is the table that shows the information only in the table1.

If it is OK with you, delete the important data, and please share your sample pbix file. Then I can try to come up with more accurate measures.

Thank you.

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster.

[RossBateman]