Forum Discussion
Backlog Calculation
Dear Community, Hope my post finds you well and healthy. I have the following problem. I want to show how many tickets were opened on a particular date and how many were closed if any. ...
It really is important which table you take fields from and put in your slicers and visuals. I'll give you a hint: Fact tables should always have all their columns hidden (never put on the canvas) and slicing and dicing should always be performed through dimensions. Stick to this rule and you'll be less surprised.
By the way, if you have to put columns from a fact table into a visual.... well, that means your design is incorrect.