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.
I have a Measure that was created called miDynamicDistance that calculated the miles between two latitudes and longitudes based on a zip code a user chooses.
I then have that measure in the filter pane on a table visual. For an example for this post, I have the measure in the filter pane set to is less than 200 to filter everyone that is less than 200 miles.
Since that is in the filter pane and not some place like a slicer, I want to display on the page either a card or another kind of visual that says show the max mileage value of the filtered measure. So in this situation, it would display 200.
Solved! Go to Solution.
It did not. I was able to get at it through a different direction. I created a table that I use for a slicer. I then use the value of the slicer in the duplicate for the formula I posted that is a conditional statement returning a Y or N to filter the table. That then allows it to display on the page the filtered value and filters the table.
hi @rrhutch
MIN or MAX is used to capture the value for a measure in a certain context. The expectation is to show the MAX value of a measure, not sure in what context does the measure return its max value. You are the best to know. Anyway, it is worthy trying to replace all or some of the MIN to MAX in your code.
It did not. I was able to get at it through a different direction. I created a table that I use for a slicer. I then use the value of the slicer in the duplicate for the formula I posted that is a conditional statement returning a Y or N to filter the table. That then allows it to display on the page the filtered value and filters the table.
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 |
---|---|
45 | |
26 | |
22 | |
13 | |
8 |
User | Count |
---|---|
73 | |
51 | |
45 | |
16 | |
12 |