Forum Discussion

MikeFleming's avatar
MikeFleming
Regular Visitor
7 months ago
Solved

FUAM DataSet

I am trying to link the Activities and semantic_models tables using ArtifactId = SemanticModelId   The measure is as follows: Last Refresh Date = VAR CurrentCalc = CALCULATE( MAX('activitie...
admin
  • v-csrikanth's avatar
    v-csrikanth
    7 months ago

    Hi MikeFleming 
    Sorry for the late response.

    The incorrect Last Refresh Date occurs because:

    • TREATAS(VALUES(semantic_models[SemanticModelId])) can return multiple IDs
    • This causes the activities table to be filtered for multiple artifacts
    • MAX(CreationDate) then returns a date from an unrelated refresh

    This is a filter-context ambiguity, not a data issue.

     

    Instead of TREATAS, explicitly filter activities using a single Semantic Model ID via SELECTEDVALUE.

    Last Refresh Date =
    VAR SemanticModelId =
    SELECTEDVALUE ( 'semantic_models'[SemanticModelId] )
    RETURN
    IF (
    NOT ISBLANK ( SemanticModelId ),
    CALCULATE (
    MAX ( 'activities'[CreationDate] ),
    'activities'[Operation] = "RefreshDataset",
    'activities'[ArtifactId] = SemanticModelId
    )
    )


    Let me know if the above mentioned works for you.

    Thanks and regards,
    Cheri Srikanth
    Community Support Team.

v-csrikanth's avatar
v-csrikanth
Community Support
7 months ago

Hi MikeFleming 

We hope you're doing well. Could you please confirm whether your issue has been resolved or if you're still facing challenges? Your update will be valuable to the community and may assist others with similar concerns.

Thank you.