TREATAS in calculated column

[Anonymous]

 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.

[v-yuta-msft · Accepted solution]

@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]

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.