Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

TREATAS in calculated column

 I have a new fact table FactAnalysis that I want to find Logged time values to by IssueID and WorkType.

 

The data is comming from FactLog (has IssueID, Logged time and Work Type) which is connected to DimIssue. 

The following simple formula does not seem to work

 

CALCULATE(

SUM(Factlog[LoggedTime]);

TREATAS(VALUES(FactAnalysis[IssueID]);DimIssue[IssueID]);

TREATAS(VALUES(FactAnalysis[WorkType]);FactLog[WorkType])
)

 

The formula gives same result for all Issue and Type combinations.

Any help is much appreciated.

 

 

  • Anonymous ,

     

    This issue should be related to the data model. Could you please share sample data and show the data structure/relationship of your data model?

     

    Regards,

    Jimmy Tao

2 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support

    Anonymous ,

     

    This issue should be related to the data model. Could you please share sample data and show the data structure/relationship of your data model?

     

    Regards,

    Jimmy Tao

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thank you for the response and for bringing forward the potential problem. The model is indeed a complicated one (10+ tables), unfortunately I cannot share it here. I think the solution here will be simplifying the model first.