Grand total not adding up in my table

[gusdahu]

Power BI Community,

I created a dashboard which includes a table showing the ammortization of payments over 67 periods. The ammortization amount within each row is correct. However, the grand total of the ammortization payments is not. How may I correct this issue? Note that the amounts within the ammortization column are coming from a measure I created. One of the variables within this measure consists of another measure. See below for a screenshot of my table.

Regards,

Gus Dahu

[Aron_Moore]

What are the formula for your measures?

[gusdahu]

Measure = DIVIDE ([Total Rent per Contract (SL)], 67)

[slanka]

Just want to make sure if the calculation for that field is set to SUM (instead of MEDIAN). Please see the screenshot.

[gusdahu]

Shanka,

The options Power BI gives me are different than your. What am I missing?

[slanka]

It's becuase i used the Table visualization to display the data and you are using Matrix (Tabular). If you change your display style to Table, then you should be able to check the Calculation for that field. Change the Calculation to SUM and then switch back to Matrix.

[gusdahu]

Hi Slanka,

I am using the tabular visual. It has to be something else.

Regards,

Gus Dahu

[slanka]

If you change your display style to Table, then you should be able to check the Calculation for that field. Change the Calculation to SUM and then switch back to Matrix.

[gusdahu]

Hi Slanka,

I meant to say that I am using the table version and the SUM option is not available to me.

Regards,

Gus Dahu

[parry2k]

@gusdahu  seems like you are using measure and that's why you are not getting the option. It is not about whcih visual to use, if you are using a column then you get aggregate options and if you are using a measure, you will not see those options since measure already has some sort of aggregation done.

So you need to confirm if you are using measure and what is the expression of your measure to find out the underline issue.

[gusdahu]

Thank you for the responnse Parry2k!

I am using a measure for this column. The measure is using a DIVIDE expression. How may I correct this issue?

Regards,

Gus Dahu

[parry2k]

@gusdahu  As mentioned in previous reply, can you share the expression you used in your measure. Without knowing and looking into it, it is very hard to explain what could be the issue.

[gusdahu]

Hello,

Measure = DIVIDE ([Total Rent per Contract (SL)], 67)

[parry2k]

@gusdahu  you have to provide teh details of all cascade measure, this divide measure is using another measure [Total Rent per Contract (SL)]