Filter based on invoice number

[Talal141218]

Hi everyone, 

I want to filter the invoice ID based on  Number. For example big than 10000 ist sales invoice and less than 10000 is returens invoice number. I should mention, that's mein data type is SQL. DirectQuery-Modus. 

Thanks in Adnvance 

[Anonymous · Accepted solution]

Hi @Talal141218 ,

If I understand correctly, you want to filter the data base on the size of the value( if number>=10000 then sales invoice else invoice number). If yes, you can create a measure as below to judge the status.

Flag = IF ( SELECTEDVALUE ( 'Table'[Number] ) < 10000, 1, 0 )

Then select the visuan and apply a visual-level fitler on the visual with the conditio(Flag is 1) just as the one in below screenshot:

If the above one can't help you, could you please provide some raw data in your tables(exclude sensitive data) with Text format and your expected result with backend logic and special examples? It would be helpful to find out the solution. You can refer the following links to share the required info:

How to provide sample data in the Power BI Forum

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