based on selected month slicer values other column values populated in visual

Hi Anonymous,

>>means i need to prepard DAX for Percenatage Archived  values for Baseline Month later i need to subtract that values for Percetgae Archived values for Compariosn month 

Since I'm not so sure the 'Comparison month' means. Does it means current row records or other? Please share more detail to help us clarify this.

If it means use current row to compare with selected value, you can refer to below steps.

1. Use percent column to create new table, and let it as the source of slicer.

Selector = VALUES('Sample'[Percent]) 

2. Write a measure to calculate with selected value.

dynamic Diff = 
var selected=SELECTEDVALUE(Selector[Percent])
return
selected-MAX('Sample'[Percent]) 

Result:

Regards,

Xiaoxin Sheng