Forum Discussion

matteo0286's avatar
matteo0286
New Member
4 years ago
Solved

Value Calculation

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...
  • matteo0286's avatar
    matteo0286
    3 years ago

    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,

Fowmy's avatar
Fowmy
Super User
4 years ago

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's avatar
matteo0286
New Member
4 years ago

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,