Finding the Corresponding Value for the Max of a Calculated measure

[Anonymous]

Hi all,

I would like to find the value corresponding to the max of a calculated measure.

Below is the matrix created, the % refers to the "Salience%" - a calculated measure: 

Salience% = DIVIDE(
SUMX(Table1,Table1[Delivered Qty]),
CALCULATE(SUMX(Table1,Table1[Delivered Qty]),ALLSELECTED(Table2[Customer),ALLSELECTED(Table1[Week#])
)

Basically, I am dividing the "delivered qty" of each "week#" by the sum of delivered qty across all weeks. 

The above salience% will change based on the slicer selections.

 Note: Table1[Week#] is a calculated column

Objective: To  create a calculated column in the Table1 for each customer, the "Max of salience%" & "CorrespondingWeek#" to the max salience

Thanks so much! 🙂  

[v-chuncz-msft · Accepted solution]

@Anonymous,

Values in a calculated column are fixed. You may use RANKX Function to add a measure and take advantage of Visual level filters.