Forum Discussion
Display Corresponding Measure Values on an Advance Card
Community SupportHi rossjmullen,
It seems thatyou want to show measure dynamically based on slicer, right? If so, you could create measure like below
Measure 3 = if(SELECTEDVALUE('Table'[name])="1", [SUM],IF(SELECTEDVALUE('Table'[name])="2",[avg]))You don't need to create select measure column in table. You could refer to my sample for details.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi dax ,
I have already found a way to display the value for the selected measure. I am trying to find a way to also display the location that has the maximum value. There are multiple locations that have data values for the given measure and I want to see which location had the highest value.
Thanks
- dax
Hi rossjmullen,
If possible, could you please explain "I am trying to find a way to also display the location that has the maximum value. There are multiple locations that have data values for the given measure and I want to see which location had the highest value" for me(show the expected output)?
Please do mask sensitive data before uploading.
Thanks for your understanding and support.
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
So this is what the entire page looks like (masked data). Each of the selections in the "Select Measure" slicer is a separate measure I created and I was able to make a dynamic slicer that allows me to show the selected measure (which I figured out using this site: https://www.burningsuit.co.uk/blog/2018/03/dax-how-to-use-a-slicer-to-select-different-measures/ ) year over year in the bar chart on the left and what each location did for the selected year (2018 in this picture). So for the selected measure "Total Supply Chain Costs, % of Non-VSD Sales" and selected year 2018 it shows that Location7 had the highest value (right chart) and I was able to display that value (14.947) in the top right in an advance card that is circled using the long measure in my original post. I want to be also display that Location7 is the location with the highest value for the selected measure and year and a way to make it dynamically change if I change the measure and/or year.
Thanks