Hi
Aquila,
This is strange indeed, it seems the relationship is not accepted, while nothing is wrong with it.
When adding a calculated column in "Legajos" with the related function, I get the correct Salary.
Yet the implicit SUM measure returns a cartesian product. This happens when there is no relationship found. Indeed when inserting the pivot I do get a warning "relation may be needed". Though it is defined in the model.
Yet trying to create an explicit measure returned me
"The column 'Legajos[IdCateg]' either doesn't exist or doesn't have a relationship to any table available in the current context."
I'm as puzzled as you by this. @
Chihiro, @
NARAYANK991, would you have a clue?