Forum Discussion
PPStar
2 years agoHelper V
How to get all data on chart
Hello. I have 2 tables. A Tickets Table and a Data Table. Date Table is related to the Tickets Table via a 1:M relationship with Date (From Date Table) and opened_at (From All Tickets Table) ...
- 2 years ago
I have been playing around, and i thnk my measures were wrong.
I fixed the measures and it appears to be working ok now.
Slim-
2 years agoFrequent Visitor
If you look at your graph in the original post, values were 46 opened and 43 closed in march.
After using USERLATIONSHIP, you have 46 opened and 42 closed.
I think your measures are good.
However, the columns in the table below do not seem to correspond to the graph (total 46 and 43 in table vs 46 and 42 in graph).
Try to plot in your table two columns : 'Calendar'[Date] and [Closed_At Count]. You should have the right numbers.
Let me know if not,
Regards
PPStar
2 years agoHelper V
I have been playing around, and i thnk my measures were wrong.
I fixed the measures and it appears to be working ok now.