Forum Discussion
Filtering Multiple Visuals with Different Filter Criteria
- 1 year ago
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.
- 1 year ago
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.
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.