Value Calculation

[matteo0286]

Hi,

I need an help.

I have one value as amount and I want to remove other amount from other filter table but only the selected item.

I can select from many filter table and the main number need to decrease for the amount selected.

Sombody can help me with this DAX command?

Thanks,

[matteo0286 · Accepted solution]

Sorry for late answer,

I solve the problem with this two measurement:

Fornitori elenco = CONCATENATEX(FILTER(all(Fornitori[Description]), not [Description] in VALUES(Fornitori[Description])), [Description], ",")

fatturato selezionato = IF(ISBLANK([Fornitori elenco]),0, sum(Fornitori[Importo residuo]) )

Thanks,

[Anonymous]

Hi @matteo0286 ,

I'm a little confused about your needs, Could you please explain them further? It would be good to provide a screenshot of the results you are expecting.

Thanks for your efforts & time in advance.

Best regards,
Community Support Team_ Binbin Yu

[Fowmy]

@matteo0286 
Can you share some sample data with the desired output to have a clear understanding of your question?
Mention whether you want a calculated column or measure.
You can either paste your data in the reply box or save it in OneDrive, Google Drive, or any other cloud-sharing platform and share the link here.

[matteo0286]

Thanks,

the DAX i try is:

Saldo Finale Mese_REAL = [Disponibilità Liquide_BPER] + SELECTEDVALUE(Fornitori[Importo residuo])

but the the amount decrease only of one single selection of that table, what i need the main amount decrease/increase of multi selction of one table

here also the screenshot:

Thanks,