topic DAX expression for below query in Developer

DAX expression for below query

rsathish_red — Mon, 25 Jun 2018 17:32:56 GMT

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?

Re: DAX expression for below query

v-jiascu-msft — Wed, 27 Jun 2018 02:31:38 GMT

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.

Best Regards,

Dale

Re: DAX expression for below query

v-jiascu-msft — Thu, 05 Jul 2018 10:03:15 GMT

Hi @rsathish_red,

Can you mark the proper answer as a solution please?

Best Regards,

Dale