Forum Discussion

RossBateman's avatar
RossBateman
Icon for Helper I rankHelper 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
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
5 years ago

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.