topic Re: based on selected month slicer values other column values populated in visual in Desktop

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

Anonymous — Thu, 12 Oct 2017 08:27:40 GMT

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.

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

Anonymous — Fri, 13 Oct 2017 02:46:06 GMT

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

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

Ashish_Mathur — Fri, 13 Oct 2017 03:02:06 GMT

Hi,

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