Struggling with FILTERS (I think). Strange behaving visualisation (PBIX linked below).

[Anonymous]

Hard to explain, so I put together a PBIX, please find it here:
https://drive.google.com/file/d/1VYvRWdwcuQDyWVd2ycsYd-RwRawoWRQx/view?usp=sharing

I've put some more details in there that will make sense when you see it.

I think the problem is aorund how I've written the dax (removing filters).  But also, seem to be getting very odd behaviour of clustered bar chart as a result.

Any help would be greatly appreciated.

[HotChilli · Accepted solution]

OK I got back to this.  Can't you make this work by replacing the JobID in the clustered column chart with the JobId from the Jobs table?

Please respond as it makes me feel like I'm not talking to myself.

[Anonymous]

Wow - that fixed it.  Thank you so much.  It never occured to me to do that, can you explain why that work ?
Now that is fixed I have the last piece of the puzzle to figure out, I'll create a new post as it's not fair to piggy back this one.  Thanks again !!!😁  

[HotChilli]

I've had a brief look and I can explain this part " The avJobLengthByType is only shown for 4 of the jobs (completely arbitrarily it seems)." The measure is not getting the context that you want for the Job[Type].  It's not in the visual so it's either getting it from the table or the slicer in the top left (not sure).  The avJobLengthByType is returning a value for the 4 jobs because they are of 'Install' type, whereas I think you want the jobtype for each job and that's not available as the measure is written.

Maybe this'll help you get started unpicking it.

If I get time tomorrow I will have another look.

Anyone else please feel free to add thoughts.