COMPUTATIONAL TOOLS SUMMARY
FORMULAS
• COUNTROWS: it returns the number of rows in the table that you specify.
1. DISTINCTCOUNT: it returns the number of distinct values of the column you specify.
1. CALCULATE
1. It resets the filter context (therefore, applying it may lead you to have a column
with all the same result as the one filtered)
1. If a filter is already present, the filter will override the filter with the new one
1. ALL shows the number of all the rows without filters
1. It takes a table and create another table as output, that is the entire table (without
any filter)
2. ALL is used within CALCULATE as one of the filters in order to remove the
filter context
1. Useful to compute PCT (percentages %) – PCT month net sales = Net sales
/ALL m. net sales
1. FILTER applies a selection (select but the others are still visible, do not filter)
1. FILTER does not really filter the table, but rather it just selects the rows that we
want to consider (so it does not alter the filter context)
2. Possible to use it in CALCULATE to have the function operating on a subset of
the table (not in all the rows of the current filter context)
1. FILTER is an integrator (goes row by row in a table)
1. REMOVEFILTERS
1. si può usare al posto di ALL
2. rather than creating a new table, it just removes all the filters that are active
1. KEEPFILTERS leave all the filters active
1. KEEPFILTERS changes the overwrite behaviour of
CALCULATE: CALCULATE does not create a new temporal filter context, it
keeps the existing one (particularly evident when the filter is applied on the same
column)
2. Generally better to use CALCULATE (FILTER (table) ALL (column))) because,
by doing so, we are filtering only one column (and not the entire table) =
less process cost when using millions of data
1. RELATED to take a column from another table
2. RELATEDTABLE to select from another table
1. DATEADD to see values from the previous year, month, or day
1. VALUE takes a column and return a table with one column that shows only the
visible values (it is affected by the filter)
1. DIVIDE, SUMX (allows to directly use column)
