topic Re: Dax search in DAX Commands and Tips

Dax search

Rish2580 — Wed, 07 Feb 2024 20:38:03 GMT

Hello, I am trying to develop a dax query to search for data in a table. Basically the query should search for data in a table which has both integers and decimal values. If I search "99" I should get all the records with 99 in it and if I search "99.99" I should get all the records with 99.99 (for example) can some please help me with the logic.

Re: Dax search

Anonymous — Thu, 08 Feb 2024 02:57:38 GMT

Hi Rish2580 ,
Based on your description, you can use the following functions in a dax query to accomplish your goal.

Here some steps that I want to share, you can check them if they suitable for your requirement.

Here is my test data:

Create dax query

EVALUATE FILTER( 'Table', 'Table'[Whole number] = 99 )

EVALUATE FILTER( 'Table', ROUND('Table'[Decimal number], 2) = 99.99 )

Final output

Best regards

Albert He

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

Re: Dax search

Rish2580 — Thu, 08 Feb 2024 02:56:07 GMT

Hello Alberto, thank you for responding. The numbers I gave was just an example. Should I use INT instead of the whole number? How can I use both the conditions in the same query as I need to search for the data in same table.

Re: Dax search

Anonymous — Thu, 08 Feb 2024 03:10:08 GMT

Hi Rish2580 ,
Set the format of the power bi data as shown in the figure. A column in power bi can only have one data format.

If you want to do both, you can try merging these two pieces of code

EVALUATE FILTER( 'Table', 'Table'[Whole number] = 99 || ROUND('Table'[Decimal number], 2) = 99.99 )

Best regards

Albert He

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