Summarize Error

[ChristofferL]

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. 

[nickchobotar · Accepted solution]

@ChristofferL

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.

[WolfBiber]

Hey,

can you post an image of your datamodel?

Greetings, 

Wolf