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 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.

 

Need Help

3 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super 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.

  • 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.