Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
i have a page with multiple filters ( both from visual and measurements),
how can i create a new measure or column that keeps all the filters that are already applied.
an example:
Page 1, Measure X = 100
Page 2, Measure X = 200 (it got to 200 by using many filters, slicers and such )
how do i create a new measure that is "equals" to Measure X on page 2 ?
Solved! Go to Solution.
🙂Still not 100% what you want to do, but as far as understanding, try this:
1- create a duplicate from the first page which you applied those filters
2- remove all charts, tables, and visuals; just keep that Card with those applied filters
3- select that cards and change the visual to the required visual
*** the other solution is to update your measure and add those filters to that - share your data and measure here to be able to work on it 😎
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate your Kudos ✌️!!
Hi @Red217
Your question is not that clear. Can you add more details to make it clear.
In General, if you create a measure and use it on different pages, it would be affected by filters of that page unless you used some codes to ignore those filters like All code.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate your Kudos✌️!!
Hi Vahid,
you are correct , sorry,
here is a picture to explain , i have a measurement that gets A LOT of filters and Slicer,
how can i copy the value to another column and KEEP ALL THE FILTERS that are already applied ?
🙂Still not 100% what you want to do, but as far as understanding, try this:
1- create a duplicate from the first page which you applied those filters
2- remove all charts, tables, and visuals; just keep that Card with those applied filters
3- select that cards and change the visual to the required visual
*** the other solution is to update your measure and add those filters to that - share your data and measure here to be able to work on it 😎
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate your Kudos ✌️!!
Thank you Vahid,
i already started build a LONG measure of "* the other solution is to update your measure and add those filters to that -"
i am using "selectedata" with all my slicers.
my questions was actually does DAX / POWERBI have a simple way to "export all filters" current filters and it seems that nope 😞
* Sorry i cant share the file , it will take me about 10 hours to "clean it"
anyway thank you for the help.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |