Grand total calculation

Hi Anonymous ,

It is probably because the intermediate table is calculating a Blank or Empty value. For instance line 5 in your table.

Adjust the measure to exclude these result or adjust your filters to exclude these situations.

If you want to change the measure, you can add a filter statement to the Ratio New measure.

Since I don't have your data is a bit of guessing, but a blank value is most likely, otherwise adjust the filter accordingly.

Jan 

Hi,

Modify your existing measure to

measure = IFERROR(SUM(Table1[Sales Amount])/SUM(Table2[Qty]),BLANK())

Now my measure will work.