Forum Discussion
Measure Calculations??
- 3 years ago
Using ALLSELECTED will take it into consideration, at the level you specify in the function. Keep in mind ALLSELECTED is a complicated function and should be used carefully.
I suggest taking some time to read the following post to get a better understanding.
Hi Euro0681 !
Measures work on the current Filter Context, your filter context is defined by al filters applied to the visualization where your measure is working, so short anwers, yes, your measure is calculated after the filter is taken into consideration. In your example, your measure will iterate on 10000 Suppliers if no fuction like ALL is being used inside it.
Question 2, if the table your are iterating for some reason contains null, sumx will iterate them
Let me know if that helps!
- Euro06813 years agoHelper II
PabloDeheza, If using allselected in my calculation will it then not take into account the page filter? The reasoning or using this is because I have some slicers that the user will then click and I want the calculation to take those into account and adjust accordingly?
- PabloDeheza3 years agoSolution Sage
Using ALLSELECTED will take it into consideration, at the level you specify in the function. Keep in mind ALLSELECTED is a complicated function and should be used carefully.
I suggest taking some time to read the following post to get a better understanding.