Forum Discussion

P_Allert's avatar
P_Allert
Frequent Visitor
1 year ago
Solved

Can't get USERELATIONSHIP to work

Hi folks,   I have a fact table for Flights (Called 'Flights') and a dimension table containing Airports (Called 'Airports'). Each row in 'Flights' represents a single flight, performed on a cert...
Need Help
  • Fowmy's avatar
    Fowmy
    1 year ago

    P_Allert 

    Please try: 

    POD IATA Measure = 
VAR SelectedPOD = SELECTEDVALUE(Flights[POD])
RETURN 
    MAXX(
        FILTER(
            Airports,
            Airports[AirportID] = SelectedPOD
        ),
        Airports[IATA]
    )
Fowmy's avatar
Fowmy
Super User
1 year ago

P_Allert 

Please try: 

POD IATA Measure = 
VAR SelectedPOD = SELECTEDVALUE(Flights[POD])
RETURN 
    MAXX(
        FILTER(
            Airports,
            Airports[AirportID] = SelectedPOD
        ),
        Airports[IATA]
    )
P_Allert's avatar
P_Allert
Frequent Visitor
1 year ago

Hi Fowmy,

thanks. It works beautifully. šŸ‘

Best regards

Patrick