Forum Discussion

rsathish_red's avatar
rsathish_red
Frequent Visitor
8 years ago

DAX expression for below query

I have 5 tables. Below the attached screenshot with tables and fields.

 

 

I need to display the reports details based on the User project id and partner id.

Users have two roles 'Project Role' and 'Partner Role'. I have created two Roles in the Powerbi report. One is for Partner and another role Project. 

 

Below the expression which is working in "import mode"

Partner Role: 

 

'Partner' = [partner_id] IN SELECTCOLUMNS (FILTER ( 'users', 'users'[id] = VALUE(USERNAME()) ),  "partners", [partner_id])

Project Role:

 

 

'Project' = [id] IN SELECTCOLUMNS (FILTER ( 'user_project', RELATED('users'[id]) = VALUE(USERNAME()) ),  "projects", [project_id])

 

Now we are using Direct query. I have created Analysis Service and created model. How should I write DAX Expression in Direct query for above scenario?

 

Need Help

2 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    Hi rsathish_red,

     

    It seems you added them in the tables as calculated columns. But the SSAS live mode doesn't support calculated columns. There could be two workarounds.

    1. Add them in the SSAS;

    2. Create a measure instead. Please give it a try. 

    DAX_expression_for_below_query

     

    Best Regards,

    Dale