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 decrease for the amount selected.

 

Sombody can help me with this DAX command?

 

Thanks,

  • 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,

4 Replies

  • 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,
  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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

  • matteo0286's avatar
    matteo0286
    New Member
    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,