Show Only Matching Values

[tksnota]

Hi 

Can someone help me on how to create a measure or m-code in showing only values that matched the Invoice Number for the fak column and don't display the rest?

//NT

[Anonymous]

Hi @tksnota 

Have you solved your problem? If so, can you share your solution here and mark the correct answer as a standard answer to help other members find it faster?

If not, could you please share your data(exclude sensitive data), or create some sample data, and your target outcome, so that we can help you better.

Thank you very much for your kind cooperation.

Best Regards

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

[tksnota]

not solved yet. i will try to share the pbix files so the forum members can help me...

[Anonymous]

Hi @tksnota 

You can refer the following links to share the required info:

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards

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

[tksnota]

thanks for the fast assistance. is it possible not to use the filter pane but shows blanks for rows that don't match so i can see the whole sheet?

[SamWiseOwl]

 If(

    SELECTEDVALUE(Sales[Invoice Number]) = SELECTEDVALUE(Sales[faktuurnr]) --Change to your tablename

    ,"Match"

    ," "

 )

Something like that?

[tksnota]

I add the measure in the table but no colum is being created as shown. am i doing something wrong?

[SamWiseOwl]

Interesting!

Do some of the rows in this table have a matching faktuurnr?

I can't see faktuurnr in your list of fields, if you add that does it work?

Is it possible that Sales[Invoice Number] on each row of your visual has multiple values in the table?

Try putting the original measure that returns 1 and 0s in, does that work?

[tksnota]

i change the faktuurns to an english name called same value. my problem is the measure won't add in the table. any reason why it can't be done?

[SamWiseOwl]

Is same value not the measure created?

I mean the original column we tested against.

Sales[faktuurnr]

Or are you saying the above column is Same Value and you cannot physically add the measure?

[Kaviraj11]

Could you create a sample pbix file, replicate the scenarios you are facing,share it with us and then myself or @SamWiseOwl can investigate further.

[Kaviraj11]

Hi,

You can create a measure as below by replacing with your columns:

Matches = IF(CALCULATE(SUM('Table'[A]))=CALCULATE(SUM('Table'[Invoice])),1,0)

Then, put the measure into the filter pane of the table visual and have it set to 1

[SamWiseOwl]

Hi @tksnota 

Create a measure like this:

Same day payment =

 If(

    SELECTEDVALUE(Sales[Invoice Number]) = SELECTEDVALUE(Sales[faktuurnr]) --Change to your tablename

    ,1

    ,0

 )

Add it into the filter pane of your visual and filter to 1: