Forum Discussion

TechMG's avatar
TechMG
Frequent Visitor
2 years ago

Convert SQL to DAX

Hi, I have a paginated report which access the source as Power BI data model, both are deployed in service. I have set of parameters exist in Paginated Report. For ex. ProgramName. It contains list o...
"Need Help"
SQL to DAX
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi TechMG ,

 

Please try:

EVALUATE
ADDCOLUMNS(
    FILTER(
        'Program',
        LOOKUPVALUE(
            'dimuser'[InternalEmailAddress],
            'dimuser'[UserId],
            'userclinicbridge'[UserId]
        ) = userprincipalname()
    ),
    'Program'[ProgramId],
    'Program'[ProgramName],
    LOOKUPVALUE('dimclinic'[ProgramId],'Program'[ProgramId]),
    LOOKUPVALUE('userclinicbridge'[ClinicId],'dimclinic'[ClinicId]),
    "InternalEmailAddress",
    LOOKUPVALUE(
        'dimuser'[InternalEmailAddress],
        'dimuser'[UserId],
        'userclinicbridge'[ClinicId]
    )
)

Best Regards,

Neeko Tang

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

TechMG's avatar
TechMG
Frequent Visitor
2 years ago

Hi Anonymous 

 

Thanks for your quick response. I have executed the query and getting below error.

Query (13, 5) Too few arguments were passed to the LOOKUPVALUE function. The minimum argument count for the function is 3.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi TechMG ,

     

    I'm sorry I changed my dax.

    Table = FILTER(ADDCOLUMNS(SELECTCOLUMNS('P',"ProgramId",[ProgramId],"ProgramName",[ProgramName]),"InternalEmailAddress",LOOKUPVALUE(
        'dimuser'[InternalEmailAddress],
        'dimuser'[UserId],
        'userclinicbridge'[ClinicId]
    )),[InternalEmailAddress]=userprincipalname())

    Best Regards,

    Neeko Tang

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

    • TechMG's avatar
      TechMG
      Frequent Visitor
      2 years ago

      Hi Anonymous ,

       

      Tried the above solution and it is saying Incorrect syntex Table.