Sometimes we would struggle about whether to use ALL or ALLSELECTED. In this article, I will introduce some tips and scenarios to help decide when to use.
ALLSELECTED(<tableName> or <columnName>)
- ALLSELECTED removes/ignores all filters but takes into account the overarching context in the report page.
- For example, most of the time we will have the “Date Slicer” on our reporting page, and we want to show the reports based on “Date Slicer”. Therefore, we…