intelicense doesn't work with Inactive relationships

[pade]

Using CALCULATETABLE to activate inactive relationships is not supported by the intelicens. See the example below , copied from Marco Russos article about handeling M2M relations, but modified to work with inactive relations.

AmountM2M :=
CALCULATE (
    SUM ( Fact_Transaction[Amount] ),
    CALCULATETABLE (
        SUMMARIZE (
             Bridge_AccountCustomer,
             Dim_Account[ID_Account]
         ),
        USERELATIONSHIP (
            Dim_Account[Account], 
            Bridge_AccountCustomer[ID_Account] 
        )
    )
)

The Power BI Desktop intelicense does not like the Dim_Account[ID_Account] column. The intelicens does not suggests the table beeing an inactive relation, but maybe worse, it markes the column as an error

Having the intelicens marking correct code as faulti makes it kind of hard to learn DAX, so please fix this bug in upcomming relases

[v-jiascu-msft]

Hi @pade,

Can you share a sample and the snapshot of the error message? What is intelicense?

Best Regards,

Dale

[pade]

Sorry for my spelling. With intelicense I mean IntelliSense.

Attaching an image

[pade]

I have a sample pbix file if you need it, but I don't know how to upload it to you