Forum Discussion

ChristofferL's avatar
ChristofferL
Frequent Visitor
8 years ago
Solved

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. 

  • 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.

     

2 Replies

  • WolfBiber's avatar
    WolfBiber
    Microsoft Employee

    Hey,

    can you post an image of your datamodel?

     

    Greetings, 

    Wolf

  • 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.