Forum Discussion

RossBateman's avatar
RossBateman
Helper I
5 years ago

Filtering a table by a measure

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 ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

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.