Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Incorrect total displayed

Hello! 🙂   I need your help and would appreciate it. First of all I show you the data model: (not the whole model, just the part we are interested in): The problem is that the total is not...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    It works now. I replaced the: SUM(CirculationFact[Count_Checkout]) with [Loans] measure in the SUMX and now it's ok.

    Now the correct measure is: 

    NEW_LOANS = SUMX(SUMMARIZE(BibliographicSubjectDim,BibliographicSubjectDim[Name]), [Loans])

     Thank you for you help.

HoangHugo's avatar
HoangHugo
Icon for Solution Specialist rankSolution Specialist
3 years ago

Hi, total row be calculated base on underlying data, in your case, watn to sum all row of table, try this one

Loans = SUMX(SUMMARIE([Name]), SUM(CirculationFact[Count_Checkout]))

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    It works now. I replaced the: SUM(CirculationFact[Count_Checkout]) with [Loans] measure in the SUMX and now it's ok.

    Now the correct measure is: 

    NEW_LOANS = SUMX(SUMMARIZE(BibliographicSubjectDim,BibliographicSubjectDim[Name]), [Loans])

     Thank you for you help.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi HoangHugo,

    Thank you for your response. Unfortunately it doesn't work ok. The amount now is much higher than expected.
    I used:  

     

    Loans2 = SUMX(SUMMARIZE(BibliographicSubjectDim,BibliographicSubjectDim[Name]), SUM(CirculationFact[Count_Checkout]))

    Do you have another idea?