Trying to make custom flag for in market and out of market time bwteen 2 tables

[wmcclure]

I am trying to make a simple comparison for time entries that looks as if the service location of a time entry is the same as the employee home branch, the time entry lives in its own table with the service location, and has a many to one relationship with cross directional filtering with the employee table which houses that persons home location.

The dax I have currently is as follows:

Out of Market Flag = IF(EXACT(Time_Entry[Service Location], 'Member'[Employee Location]), "In Market", "Out of Market")

I have tried a few different variations but I cant seem to get the function to want to take the service location and employee location as inputs. I am sure what I am missing is simple but for the life of me I cant seem to find an example of this online to use for comparison.

Thanks in advance!

[v-xuxinyi-msft · Accepted solution]

Hi @wmcclure 

I would like to apologize for the belated reply.

Have you solved your problem? If it's not resolved, you can try the following methods.

Replace measure with the following:

Out of Market Flag = IF(EXACT(SELECTEDVALUE(Time_Entry[Service Location]), SELECTEDVALUE('Member'[Employee Location])), "In Market", "Out of Market")

My sample:

Is this the result you expect?

Best Regards,
Community Support Team _Yuliax

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Fowmy]

@wmcclure 

Create the following calculated Column in your Time Entry table:

Out of Market Flag =
IF (
    Time_Entry[Service Location] = RELATED ( 'Member'[Employee Location] ),
    "In Market",
    "Out of Market"
)

[wmcclure]

I am still getting the red underlines, it wont let me use it on any viusals either. Is there a debug tool I might be missing that can tell me why the statement is failing?

[Fowmy]

@wmcclure 

Sharing a dummy Power BI file representing your scenario would be beneficial. You can save the Power BI file on Google Drive or any other cloud storage platform and provide the link here. Kindly ensure that permission is granted to open the file.

[wmcclure]

Unfortunately I dont think I would be comfortable doing as such. This dataset contains information like employee compensation, If it comes down to it I can go into power query, I was just hoping that there was some sort of step I missed to get DAX to accept the text fields for comparison

[Fowmy]

@wmcclure 

Sorry, without having a clear understanding of your model, suggesting solutions will be hard.
If you could create a dummy model to represent your case then it will be helpful.