Latest Enterprise DNA Initiatives

Totaling row values calculated by DAX 'min' formula

This is probably a familiar problem, but I was not able to apply solutions for this seemingly oft-occurring issue. Problem Statement: Calculate row total of a DAX formula – “Acquisition Cost (USD equiv.)”. It appears PBI is simply re-applying the formula to the column total, which results in incorrect total of $1,206, rather than computing $547,568. .pbix file is attached:
Issue with totaling results of MIN Dax formula.pbix (59.7 KB)
Forecast depreciation - Sample.xlsx (50.9 KB)

Hi @mdalton2100,

Have a look at the attached file, i created a new measure Sum Min
Issue with totaling results of MIN Dax formula v1.pbix (61.4 KB)

1 Like

Hi @mdalton2100, did the response provided by @KimC help you solve your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark as solution the answer that solved your query. Thanks!

Thanks @KimC … works perfectly.