Forum Discussion

RichOB's avatar
RichOB
Post Partisan
10 months ago
Solved

Changing the total calculation in table

Hi, how can I change the total in the Family Payment column to show £7045.38, not "260.94? The measure for this column is:   Family_Payment = CALCULATE( SUM( 'Table1'[Amount] ), 'Table1'[Desription...
Need Help
  • Anonymous's avatar
    Anonymous
    10 months ago

    Hi RichOB ,

    Thanks for reaching out to the Microsoft fabric community forum. 

     

    After thoroughly reviewing the details you provided, I try to workon my end. I have used some sample data on my end and successfully implemented it.     

    I am also including .pbix file for your better understanding, please have a look into it:

    Hope this resolves your issue. Please feel free to reach out for any further questions.

    Thank you 

ivana_tomekova's avatar
ivana_tomekova
Advocate II
10 months ago

Hi... this look strange, because formula looks OK.... so problem would be probably somewhere on model level.... can you share your pbix file?... or what is the formula for Government payment?... do you have data in Table1 aggregated by year week?.... to me it looks like that week specification in Table1 is missing, therefore for every week and also for total just same amount is used.