Forum Discussion
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...
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.
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]))
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.