Forum Discussion
Solved
How to sum with relations?
After using my buddy Google for two hours without the expected result, I want to use your help. I Have the following case: Table A (Artikelpost) Entry No. Itemno. Tot. werk. omzet 100 7454...
hi Jelto
First, you should know that:
- Calculation column/table not support dynamic changed based on filter or slicer.
- Measure can be affected by filter/slicer, so you can use it to get dynamic summary
https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/
For your requirement, you need to create a measure instead of column.
total Tot. Werk. Omzet = CALCULATE(SUM(WS_Waardeposten[Tot. Werk. Omzet]))here is sample pbix file, please try it.
Regards,
Lin
v-lili6-msft
Community Support
Community Supporthi Jelto
First, you should know that:
- Calculation column/table not support dynamic changed based on filter or slicer.
- Measure can be affected by filter/slicer, so you can use it to get dynamic summary
https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/
For your requirement, you need to create a measure instead of column.
total Tot. Werk. Omzet = CALCULATE(SUM(WS_Waardeposten[Tot. Werk. Omzet]))
here is sample pbix file, please try it.
Regards,
Lin