Forum Discussion

Didik62's avatar
Didik62
Frequent Visitor
4 years ago
Solved

Asking : How to showing selected row data (some column) based based on dynamic max value

I am looking for how to visualize the table for entire data with max value as reference and following the selected filter (by slicer) Here my data   Area code Product Code Age Qty A Prod...
  • Anonymous's avatar
    Anonymous
    4 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 Zhou

     

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