Forum Discussion

Impactful Individual

8 years ago

relationship setup

Hi, how to easily setup the interaction between all of the visuals and charts. for instance i have 2 tables (Inbound and outbound) contains the same information. I had to split this to 2 tabl...

Impactful Individual

8 years ago

I have used the below DAX for creating a newtable as region

Region =
FILTER(
DISTINCT(
UNION(
DISTINCT(Inbound[HQRegion]),
DISTINCT(Inbound[DeliveryRegion])
)
),
NOT(ISBLANK(Inbound[HQRegion])))

Go so far as to hide the HQRegion fields in both the Inbound and Outbound table? Not sure why i have to hide this?

Microsoft Employee

8 years ago

I only suggested you hide those fields so you don't accidentally use them in your slicer, or on an axis.

Phil_Seamark
Microsoft Employee
8 years ago
Just to be clear. Only use fields from the middle tables (surrounded by the red rectangle) for your slicers and on the axis of your visuals.

Do not use ANY fields from the two tables with the red crosses in a slicer or on the axis of a visual. You can use numeric fields from these tables for measures etc.
- vjnvinod
  Impactful Individual
  8 years ago
  Phil_Seamark Mond
  
  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
  - Phil_Seamark
    Microsoft Employee
    8 years ago
    Got the file, so if I select Africa from the region slicer. what is the issue? I don't see any errors.