Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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,
Solved! Go to 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,
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,
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
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.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Thanks,
the DAX i try is:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
26 | |
21 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |