Forum Discussion
Dax Error
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
Anonymous
Please tryAmbassador = IF ( ISEMPTY ( CALCULATETABLE ( VALUES ( Ambassador[Ambassador Email] ), USERELATIONSHIP ( Ambassador[Ambassador Email], 'T1 Data Base'[User Email] ) ) ), "No", "Yes" )
13 Replies
Hi
Would you please share ascreeshot of your data model with th erlationships?Anonymous
Please tryAmbassador = IF ( ISEMPTY ( CALCULATETABLE ( VALUES ( Ambassador[Ambassador Email] ), USERELATIONSHIP ( Ambassador[Ambassador Email], 'T1 Data Base'[User Email] ) ) ), "No", "Yes" )Hai tamerj1 Yes it's working , can you explain why you used isblank here
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
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