Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

USERELATIONSHIP TWICE IN SAME MEASURE

Hi everyone!   I have a a mapping table for countries that connect to my main table in two relationships source and destination. Im trying to calculate exports and imports with the following measu...
Need Help
v-alq-msft's avatar
v-alq-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi, Anonymous 

 

We recommend you pass filter arguments as Boolean expressions, whenever possible. It's because Import model tables are in-memory column stores. They are explicitly optimized to efficiently filter columns in this way.

However, there are some restrictions that apply to Boolean expressions when they're used as filter arguments. They:

  • Cannot compare columns to other columns
  • Cannot reference a measure
  • Cannot use nested CALCULATE functions
  • Cannot use functions that scan or return a table

 

Instead, you'll need to use table expressions for more complex filter requirements. For further information, I'd like to suggest you refer to the document .

 

Best Regards

Allan

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

So Im getting closer to the solution but still not there

 

I created a measure to calculate the values Im trying to map first

 

1. Dest_Node_Type = CALCULATE(FIRSTNONBLANK('New Mapping'[Node Type],1),USERELATIONSHIP(LinkData[DestNodeName],'New Mapping'[Name]))
 
2. 
Dest_Country = CALCULATE(FIRSTNONBLANK('New Mapping'[Country],1),USERELATIONSHIP(LinkData[DestNodeName],'New Mapping'[Name]))
 
While Source Node Type  and source country I get it by just grabbing the field in table as it is the active relationship.
 
 
I then use it like this and seems to work as in I dont get any errors.
 
Gas Pipe Exports =
CALCULATE([Gas Outflow],'New Mapping'[Node Type]="Transportation", FILTER('New Mapping','New Mapping'[Country] <> [Dest_Country]))
 
However, when checking the mapping values in a table. The measures I'm using creating the use relationship measure seem to be picking the names from the active relationchip and not the unaactive relationship value.
 
Active Relationship:
 
Source Node name --> Name
 
Not active
 
Dest Node Name --> Name
 
Any ideas why this could be happening?