Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only

Use RELATED in Direct Query mode

  • 1.  Use RELATED in Direct Query mode

    Posted Jan 06, 2022 06:36 AM
    Morning,

    I have a small problem with my dax code in Direct Query mode. Indeed, I want to order the names of some stations in a column.
    So I have created an index table with two columns: station_name, station_order.
    I have established a 1-1 relationship between station_name and station_name in my dim_station_origin table.
    Then I created a calculated column in dim_gare_origine with the function dax: Related(index(column)).
    I have the following error: "The column "Index_Station_Order[Station_Order]" does not exist or has no relationship to any table available in the current context."
    Can someone help me? Thanks




    ------------------------------
    Jédielle HOUNSONLON
    Alternante data
    ------------------------------