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

Question

I have 2 columns in databased IDMonthYear and PercentageArchived and for every month value is different for Percentage Archived.table is like below&nbsp;&nbsp;BaselineIDMonthYear PercentageArchivedApr-17&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 100.00Apr-17&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;118.33Apr-17&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1.73Aug-17&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0.00Aug-17&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0.00Dec-17&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0.00Dec-17&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0.00&nbsp;so when user select any month from that slicer for that particular month values is populated PercentageArchived&nbsp;dynmically.&nbsp;means i need to prepard DAX for Percenatage Archived&nbsp; 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.&nbsp;

anonymous · Accepted Answer

Hi&nbsp;Anonymous,
&nbsp;
&gt;&gt;means i need to prepard DAX for Percenatage Archived&nbsp; values for Baseline Month later i need to subtract that values for Percetgae Archived values for Compariosn month&nbsp;
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.
&nbsp;
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])

&nbsp;
2. Write a measure to calculate with selected value.
dynamic Diff = 
var selected=SELECTEDVALUE(Selector[Percent])
return
selected-MAX('Sample'[Percent]) 
Result:

&nbsp;
Regards,
Xiaoxin Sheng

Forum Discussion

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

2 Replies

Related content

Selected slicer

Slicer default selection

Single select slicer

Between date slicer - calender selection

Slicer Clear Selection White