Forum Discussion
relationship setup
Hi thanks for the suggestion, but doesn't seems to be working, look at my scrubbed pbix file below.
https://www.dropbox.com/s/kaqbg9fc8h3wpo1/testchecknew.pbix?dl=0
My issues starts while i filter for a specfic value in the region, could be any region and i realised that tables/charts, doesn't interact properly.
However it works with my filter for Account sector.
Do let me know, if there is way i can fix this, i must be doing something incredibly wrong.
thanks for taking time and suggesting any change
Got the file, so if I select Africa from the region slicer. what is the issue? I don't see any errors.
Right, you may not find the issue while selecting the region as africa, what you need to do is select the region Africa and then click on Outbound to americas & the result is weird, below is what i see
Sector Revenue View is Blank (No value is getting displayed)
Account sector view is blank
Inbound matrix/table is Blank
thus making me feel that, its not interacting with other Matrix & charts,
attach is the screenshot.
Hi vjnvinod
It's been overnight here and I'm back at work now. I will try to look at this later today. I suspect we might need to code a bit of DAX to get the result you are after.