Forum Discussion

New Member

8 years ago

Relationships and calculated columns

First of all: Hello! Newbie here! Nice to have found a place to learn... I might have been trying this all the wrong way, but here goes: A have four different tables, each containing info...

Icon for Microsoft Employee rank

Microsoft Employee

8 years ago

Hi ArjanLoogman

Any chance you can post a screenshot of your relationship view for these tables?

New Member

8 years ago

Hi Phil_Seamark,

Here it is...

Had to translate the project into English, took a while.

Kind regards,

ArjanLoogman

v-huizhn-msft
Microsoft Employee
8 years ago
Hi ArjanLoogman,

Please change the single filter to both cross filter direction as follows. Then check if it works fine.

Best Regards,
Angelia
- ArjanLoogman
  New Member
  8 years ago
  Hi Angelia,
  
  Thank you for your tip! Unfortunately, this didn't solve the situation.
  
  Riddle me this:
  
  I've succeeded doing a similar count with two simple tables: one table with a column for teacher names and another table with a column for class number (1-10) and a column for attending teacher.
  
  using both: numClasses = COUNTROWS(FILTER(Classes;Classes[Teacher]=Teachers[Teachers]))
  and: numClasses = COUNTAX(FILTER(Classes;Classes[Teacher]=Teachers[Teachers]);[Teachers])
  
  I've managed to calculate how many classes each teacher has given.
  
  Unfortunately, these formulas don't work on my other project.
  
  The only difference between Classes[Teacher] and the column from my problematic project, Dentists[CityRegion], is the fact that the latter is a calculated column based on a lookup from a related table: CityRegion=Related(CityRegionsAndZipCodes[CityRegion])
  
  Classes[Teacher] is simply a manually filled column.
  
  Thoughts, anyone?
  
  Kind regards,
  
  ArjanLoogman