Forum Discussion

nikkirai99's avatar
nikkirai99
Frequent Visitor
1 year ago
Solved

Error fetching data for this visual - column, relationship or measure not in a valid state

I have a Table 1 which is the main table called 'Main' and Table 2 called 'Reason Codes'.  Table 1 has 100 rows. Table 2 has 5 rows which match Table 1.   My calculated column is below: If(     ...
Need Help
  • rajendraongole1's avatar
    rajendraongole1
    1 year ago

    Hi nikkirai99  - Your formula itself is correct for what it intends to do, the way the RELATED function works in DAX and the setup of relationships between your tables.there is a one-to-many relationship between Reason Codes (one side) and Main (many side).

     

    create simple measure as like below for test:

    TestColumn = RELATED('Reason Codes'[ReasonCodeDate])

    If this also results in an error, the issue is with the relationship.  still, If the relationship is valid but still causes issues, try an alternative approach using LOOKUPVALUE

     

    ReasonCodeDateResolved =
    LOOKUPVALUE(
    'Reason Codes'[ReasonCodeDate],
    'Reason Codes'[ReasonCodeID], 'Main'[ReasonCodeID]
    )

     

    This formula does not depend on the RELATED function and works even with inactive relationships.Focus on verifying the relationship between the tables and testing the logic with simpler measures.

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Thanks for the reply from danextian  and rajendraongole1 , please allow me to provide another insight:

Hi, nikkirai99 
 

Thank you for reaching out to the Microsoft Fabric community forum.

 

We appreciate you sharing the issue you encountered and pointing out that it might be a known problem. This information is very helpful for other community members who might be facing similar issues.

 

Additionally, I agree that the alternative solution mentioned by rajendraongole1 is a good idea. You can try using the LOOKUPVALUE() function to temporarily resolve your issue.

Here is the relevant documentation link:

LOOKUPVALUE function (DAX) - DAX | Microsoft Learn

 

Once again, thank you for your contribution. If you have any new discoveries or questions, please feel free to get in touch with us.

 

Best regards,

Leroy Lu