Multiplying DAX Measure by Column on a bar chart to have the total balance

[Asantos2020]

Hello,

I have a DAX measure, giving me the qty balance on a bar chart (date on X axis) and filtered on Product basis:

SaldoMovimento = IFERROR(CALCULATE(SUM(BI_Estoque_Movimentacao[Quantidade]);FILTER(ALL('Calendário'[Date]);'Calendário'[Date]<=MAX('Calendário'[Date])));BLANK()) 

I now need to have a column stating this balance in $. I have a Unit Cost column, Unit Cost as a DAX Measure, but I can't find a way to find the right result.

Thanks in advance for your help!

Cheers,

Antonio 

[v-lili6-msft · Accepted solution]

hi @Asantos2020 

You may try to use SUMX Function instead of SUM in the formula, please refer to these blog:

https://exceleratorbi.com.au/use-sum-vs-sumx/

https://powerpivotpro.com/2014/10/sum-sumx-or-calculatechoices-choices/

If not your case, please share some sample pbix file and your expected output.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Regards,

Lin

[Asantos2020]

Hello @v-lili6-msft ,

Thanks for the heads-up.

When I was putting together the data to provide you with a file, I figured that the same calculation I used for having Inventory Balance in Qty worked for values. I then saw that the data made available contains inconsistencies value wise.

Cheers,

Antonio Santos