Forum Discussion
Asking : How to showing selected row data (some column) based based on dynamic max value
- Anonymous4 years ago
Hi Didik62
I think you can try Max, Sum function in value field in table visual and create a measure to achieve your goal.
Max of Age column is Age column from table calculated by Maximum function in table visual.
Total Qty of Product column is Qty column from table calculated by Sum function in table visual.
Qty of Max Age is as measure.
Qty of Max Age = CALCULATE(SUM('Table'[Qty]),FILTER(ALL('Table'),'Table'[Product Code] = MAX('Table'[Product Code])&&'Table'[Age] = MAX('Table'[Age])))Create a slicer by Area code column from table. Result is as below.
All:
Select A:
Select B:
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Didik62
I think you can try Max, Sum function in value field in table visual and create a measure to achieve your goal.
Max of Age column is Age column from table calculated by Maximum function in table visual.
Total Qty of Product column is Qty column from table calculated by Sum function in table visual.
Qty of Max Age is as measure.
Qty of Max Age =
CALCULATE(SUM('Table'[Qty]),FILTER(ALL('Table'),'Table'[Product Code] = MAX('Table'[Product Code])&&'Table'[Age] = MAX('Table'[Age])))
Create a slicer by Area code column from table. Result is as below.
All:
Select A:
Select B:
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you so much. it works for me.