Forum Discussion

Priesling's avatar
Priesling
Copper Contributor
Nov 12, 2024

Trying to use a user input within a DAX query

Hello Everyone.


Currently trying to use a userinput made in Copilot studios from the user and implementing it in the DAX query. However it is not working. Do any of you have some knowledge on how to succeed?

code snippet.

 

DEFINE

    VAR UserInput = Var2

 

EVALUATE

TOPN(

    100,

    SELECTCOLUMNS (

        FILTER (

            'Table',

            'Table'[Adresse] = UserInput

        ),

        "Ejendom", 'Table'[Ejendom],

        "Adresse", 'Table'[Adresse]

    )

)

No RepliesBe the first to reply