Forum Discussion
Display Corresponding Measure Values on an Advance Card
This is what the numbers in the measure are referencing above.
daxCommunity Support
Hi 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 ZhiIf 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.
- amitchandak
Super User
You need to get the location for max value like this and then create a similar kind of filter again
location 1 = calculate(max(location[location],filter(table,table[Costs per Sq Meter MAX]= [WHS Fixed Costs per Sq Meter MAX] ))Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p/881739
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601This measure is returning the last location alphabetically and if i were to change it to MIN it returns the first location alphabetically. Is there something else to make the corresponding location to the maximum location value?
Thanks
