Wacky result in powerbi desktop table visual

[scondon1985]

I have two table visuals on top of each with the same columns in PBI desktop. Both visuals display the correct results that are filtered by both slicers at the top of the screen.

Column "Process Name" comes from BatchRoots table. Column "path" comes from Processes table. BatchRoots has a one-to-many relationship to Processes based on the "Process Name" column.

When i add a hardcoded measure = 1 to one of the table visuals, the "path" values appear to be ALL paths for all records in Processes table. It looks like it is not respecting the filter being applied by the "Jobs" slicer.

I would include my .pbix file, but it includes confidential data. All help will be greatly appreciated. Thank you

ADDITIONAL INFO:

This is the filter definition for Job slicer:

[v-nmadadi-msft]

Hi @scondon1985 

May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions.

Thank you

[v-nmadadi-msft]

Hi @scondon1985 

I wanted to check if you had the opportunity to review to provide the requested information. Please feel free to contact us if you have any further questions.

Thank you.

[v-nmadadi-msft]

Hi @scondon1985 ,

I have tried to look for possible solutions to your issue, but could not because of lack os some valuable data.

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information. Do not include anything that is unrelated to the issue or question.

Please show the expected outcome based on the sample data you provided.

Thank you

[parry2k]

@scondon1985 can you share the expression of any other measure, not the hardcoded one, still not able to connec the dots why it is happening.

It will be easier if you share pbix file using one drive/google drive with the expected output. Remove any sensitive information before sharing.

[scondon1985]

@parry2k Hi Parry,

I am just using a hardcoded measure as a simple example. Every formula I try behaves the same way. Unfortunately the same thing happens when I change that relationship cross-filter direction to Single.

[scondon1985a]

@parry2k

I get same result if the cross-directional filter direction is "Single". I am using a hardcoded measure just as a simple example. Same phenomenon happens with all the other measures I have used.

[scondon1985a]

@parry2k

I get same result if the cross-directional filter direction is "Single". I am using a hardcoded measure just as a simple example. Same phenomenon happens with all the other measures I have used.

[scondon1985a]

@parry2k

I get same result if the cross-directional filter direction is "Single". I am using a hardcoded measure just as a simple example. Same phenomenon happens with all the other measures I have used.

[parry2k]

@scondon1985 change cross filter direction from both to single, and why are you using a hardcoded measure? What is your end goal?