Forum Discussion
Summarize Error
I have experienced attached issue summarizing my data. I KNOW my numbers have been correct ealier on, so I wonder if it is some update that courses the problem or if I have overlooked something important.
I would do the following testing :
How did you create your summarized Table 1 ?
Are you sure your date slicer is set on both tables ?
How many rows you get if you run this measure on your transactional table ?
= CALCULATE (
COUNTROWS(Table2),
Table2[No] = "<Credence ID>")
Fyi: that Credence ID ends with 112 in your dataset rather than 116 as shown in your example.
2 Replies
- WolfBiberMicrosoft Employee
Hey,
can you post an image of your datamodel?
Greetings,
Wolf
- nickchobotarSkilled Sharer
I would do the following testing :
How did you create your summarized Table 1 ?
Are you sure your date slicer is set on both tables ?
How many rows you get if you run this measure on your transactional table ?
= CALCULATE (
COUNTROWS(Table2),
Table2[No] = "<Credence ID>")
Fyi: that Credence ID ends with 112 in your dataset rather than 116 as shown in your example.