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,

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,