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.
Can someone explain me why does a simple SUM not work?
Is it somehow implacable that I have that bridge table in the data model?
Here I attached the pbix file: https://files.fm/f/emwb7m5fy