Forum Discussion
Summarize Error
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.
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.