Forum Discussion
Dax Error
Anonymous
Please tryAmbassador = IF ( ISEMPTY ( CALCULATETABLE ( VALUES ( Ambassador[Ambassador Email] ), USERELATIONSHIP ( Ambassador[Ambassador Email], 'T1 Data Base'[User Email] ) ) ), "No", "Yes" )
Anonymous
Please try
Ambassador =
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/2550780Anonymous
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
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