Forum Discussion

Riyaz999's avatar
Riyaz999
Icon for Helper II rankHelper II
1 year ago
Solved

Using RELATED DAX function in FACT table from SQLServer

Hello there,   I have a FACT table that is sourced from a SQL Server Database (FireWeatherData).  I have related this table to a local table in Power BI (Metric).  I have tried using the RELATED DA...
Need Help
  • Riyaz999's avatar
    Riyaz999
    1 year ago

    I was on the right track with:

    CALCULATETABLE(
        ADDCOLUMNS(
            'ReportMetric',
            "FieldName", LOOKUPVALUE('Field'[FieldName], 'Field'[FieldId],'ReportMetric'[MetricId])
        ),
        FILTER(ReportMetric, 'ReportMetric'[ReportId] = [seletectedReportId])
    )
     
    Unfortunately, I was missing a relationship between my dax table and the Reports table.
    Works now.  Thanks for everyone's help.
v-aatheeque's avatar
v-aatheeque
Icon for Community Support rankCommunity Support
1 year ago

Hi Riyaz999 

Just following up on the issue you raised about sorting MetricId by your CalculatedOrdinal field and the challenges with filtering ReportMetricTable. 

Were you able to try out the suggestions shared by lbendlin (like the note about RELATED only working in many:one relationships)?

Riyaz999's avatar
Riyaz999
Icon for Helper II rankHelper II
1 year ago

I was on the right track with:

CALCULATETABLE(
    ADDCOLUMNS(
        'ReportMetric',
        "FieldName", LOOKUPVALUE('Field'[FieldName], 'Field'[FieldId],'ReportMetric'[MetricId])
    ),
    FILTER(ReportMetric, 'ReportMetric'[ReportId] = [seletectedReportId])
)
 
Unfortunately, I was missing a relationship between my dax table and the Reports table.
Works now.  Thanks for everyone's help.
  • v-aatheeque's avatar
    v-aatheeque
    Icon for Community Support rankCommunity Support
    1 year ago

    Hi Riyaz999 

    Glad to hear the earlier approach helped resolve your issue once you added the missing relationship.

    Could you confirm if everything is now working smoothly with your DAX table and reports, or if you still need any further assistance?

  • Riyaz999's avatar
    Riyaz999
    Icon for Helper II rankHelper II
    1 year ago

    Confirmed, the issue I raised here has been resolved.

  • v-aatheeque's avatar
    v-aatheeque
    Icon for Community Support rankCommunity Support
    1 year ago

    Hi Riyaz999 

    We’re glad to hear that your issue has been resolved! Please continue to use the Microsoft Fabric Community platform whenever you have questions.

     

    If the responses above helped address your query, kindly click Accept Answer , If you have any further queries, feel free to reach out.

     

    Thank you for being part of the Microsoft Fabric Community!