Forum Discussion
Filtering Multiple Visuals with Different Filter Criteria
Hi tomperro
You can create measures that are filtered, using calculate dax function...
like :
KPI1 = Calculate (sum('table'[something]),filter('table'[Last Name = "Jones"])
This measure will return filtered result.If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
This is all we have ....
Filters / Slicers or filter inside measures..If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
The measures are not part of the table; they are not "active" unless they are in a visualization. Technically, this is an advantage because it saves on model size.
At the same time, in terms of functionality, this approach does meet your needs. If you want to make changes, you simply update the measure. From the user's perspective, there is no need to change anything, as what will appear in the visualization is your measure, which remains consistent unless you modify the code.
I am trying to avoid changing multiple measures if I ever have the need to add or remove filters.
If each KPI has 4 measures, each with a set of filters and if I ever need to modify those filter, I would rather change it in once place rather that changing the 4 measures.
This is all we have ....
Filters / Slicers or filter inside measures..If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.