Power BI Dax - IF with calculatetable

[Anonymous]

Hello Everyone,

We are working on creating Dynamic RLS for one of our reports, and we are facing issues in DAX. Below is the DAX, It is working fine if we remove IF condition. But if we use IF condition with CalculateTable the results are not as expected.

[region] IN IF(CONTAINS(analytics_auth1, [emailid], USERPRINCIPALNAME(), [access_type1], "Region"),
   CALCULATETABLE( SELECTCOLUMNS(analytics_auth1, "level1", [level1]),  FILTER(analytics_auth1, [emailid] = USERPRINCIPALNAME())), [region] )

Please let me know your suggestions why it is not working with IF condition.

Thank you in advance.

Arvind

[v-yulgu-msft]

Hi @Anonymous ,

Please provide some dummy data, and show us the difference of the result return by formula with IF condition and without IF condition. If using IF condition, is there any error?

Regards,

Yuliana Gu