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

[Anonymous]

I have 2 columns in databased IDMonthYear and PercentageArchived and for every month value is different for Percentage Archived.

table is like below 

BaselineIDMonthYear PercentageArchived
Apr-17                            100.00
Apr-17                             118.33
Apr-17                             1.73
Aug-17                            0.00
Aug-17                            0.00
Dec-17                           0.00
Dec-17                           0.00

so when user select any month from that slicer for that particular month values is populated PercentageArchived dynmically.

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 . i am new in DAX so please help out achived abobe scenario. 

[Ashish_Mathur]

Hi,

Your question is not clear.  Based on the dataset that you have pasted, please show the expected result.

[Anonymous · Accepted solution]

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