Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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 ,
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
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.
User | Count |
---|---|
98 | |
90 | |
78 | |
72 | |
65 |
User | Count |
---|---|
114 | |
98 | |
96 | |
68 | |
67 |