Forum Discussion

at8's avatar
at8
Frequent Visitor
3 years ago
Solved

Power KPI matrix- Compare based on Slicer selection

https://drive.google.com/file/d/1JpDTTSjJAR8U3k5Bt4SuJORAU8Se2Umz/view?usp=drivesdk   In the above power Bi file, i am using the power KPI matrix. I have a colum with date, name and age. i want to ...
Need Help
v-jianboli-msft's avatar
v-jianboli-msft
Community Support
3 years ago

Hi at8 ,

 

Please try:

Measure = 
var _a = ALLSELECTED(Sheet1[Name])
return MAXX(FILTER(ALL(Sheet1),[Name] in _a),[Age])

Final output:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.