topic Re: Dax Error in DAX Commands and Tips

Dax Error

Anonymous — Wed, 01 Jun 2022 11:27:48 GMT

Hai All, please help me to solve this error,
I am trying to create a flag, but these two tables are in an inactive relationship,

The logic is if the ambassador's name is present in the t1 table then yes otherwise no but these two tables are in inactive mode
and I am getting this error so how to solve this error please help me

Re: Dax Error

Anonymous — Wed, 01 Jun 2022 11:34:33 GMT

Hello You missed a column in Relationship formula.

Store the value of the relationship in a variable and compare it after

Re: Dax Error

Anonymous — Wed, 01 Jun 2022 11:36:43 GMT

No, I didn't miss anything

Re: Dax Error

tamerj1 — Wed, 01 Jun 2022 11:47:55 GMT

Hi
Would you please share ascreeshot of your data model with th erlationships?

Re: Dax Error

Anonymous — Wed, 01 Jun 2022 11:49:34 GMT

Sure tamerj1

This is the relation with these two tables

Re: Dax Error

tamerj1 — Wed, 01 Jun 2022 11:51:45 GMT

Anonymous
Are you creating a column (calculated column) or a measure? If you are creating a calculated column then please advise in which table?

Re: Dax Error

Anonymous — Wed, 01 Jun 2022 11:52:59 GMT

Hai tamerj1 I am creating a calculated column in T1 Database table

Re: Dax Error

tamerj1 — Wed, 01 Jun 2022 12:03:05 GMT

Anonymous
Please try

Ambassador = IF ( ISEMPTY ( CALCULATETABLE ( VALUES ( Ambassador[Ambassador Email] ), USERELATIONSHIP ( Ambassador[Ambassador Email], 'T1 Data Base'[User Email] ) ) ), "No", "Yes" )

Re: Dax Error

Anonymous — Wed, 01 Jun 2022 12:04:28 GMT

Hai tamerj1 Yes it's working , can you explain why you used isblank here

Re: Dax Error

Anonymous — Wed, 01 Jun 2022 12:06:35 GMT

Hai tamerj1, am accepting this solution, and can you please help me to achieve this requirement too
https://community.powerbi.com/t5/Desktop/Converting-static-to-Dynamic-Measure/m-p/2550780

Re: Dax Error

tamerj1 — Wed, 01 Jun 2022 12:09:35 GMT

Anonymous
I changed my reply to ISEMPTY for more simplicity.
You have one to many relationship between the two tables. If you want to pul values from the many side to the one side it won't be a single value for each row. Rather it would be multiple values (a table). If now values are return then this table is EMPTY or the number of its rows ISBLANK

Re: Dax Error

Anonymous — Wed, 01 Jun 2022 12:09:41 GMT

Hai tamerj1 Thank you for the solution
Please check this requiremtn
https://community.powerbi.com/t5/Desktop/Converting-static-to-Dynamic-Measure/m-p/2550780

Re: Dax Error

tamerj1 — Wed, 01 Jun 2022 17:07:54 GMT

Re: Dax Error

Anonymous — Wed, 01 Jun 2022 16:41:22 GMT

Sorry, for which question you have answered this?