Generate series using measure result (shown in a card) as the maximum value for the slicer??

[TonyKuiper]

I have several slicers on a report and they all run on parameter built generateseries() functions.

One of the slicers is currently set to 1-24 month as static inputs in the function. It is used as a sort of discount against the months consumed for a customer job.

I have tasks that run less than this max amount ie 4 months.

I have a measure will shows the months against the customer task in a card visual.

I would like to (if possible) use that value as the maximum for the generateseries() so that the slicer is limited to whatever the maximum months are based on the customer filter.

This is to prevent a 4 month job being given a 6 month discount... if that makes sense.

Is this even possible? I have tried writing some min/max type statements into the function but they aren't working. I have tried generating a table which sort of worked but then stayed at the first value generated and didnt update when the customer was changed.

I'm really looking to grab the actual number from the card visual and use that.

Thanks

Tony

[grazitti_sapna]

Hey,

You can try using SelectedValue function in dax 

Like this:- Measure = IF(SELECTEDVALUE('Free Months'[Free Months],0)>[MaxFreeMonths],[MaxFreeMonths],SELECTEDVALUE('Free Months'[Free Months],0))

I hope this will help.

[TonyKuiper · Accepted solution]

So I managed to sort this out. I added the measure value into the selectedvalue part of the parameter by using an if statement...

Free Months Value = IF(SELECTEDVALUE('Free Months'[Free Months],0)>[MaxFreeMonths],[MaxFreeMonths],SELECTEDVALUE('Free Months'[Free Months],0))

Simple with the benefit of hindsight 🙄