Filter based on invoice number

Talal141218 — Mon, 17 Apr 2023 11:04:28 GMT

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

Re: Filter based on invoice number

Anonymous — Wed, 19 Apr 2023 03:18:49 GMT

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

topic Re: Filter based on invoice number in DAX Commands and Tips

Filter based on invoice number

Re: Filter based on invoice number