Forum Discussion

Jayaselvan's avatar
Jayaselvan
Helper II
4 years ago

Dynamic What If Paramter

Hello All,   I have to create a simulation page based on user inputs. I have used 4 What if paramter for that. The value range will be from 0 to 40,000. As What if paramter takes 1000 values only. ...
Need Help
amitchandak's avatar
amitchandak
Super User
4 years ago

Jayaselvan , In generateseries if execute at grand total level, no row context unless you force one. Also no slicer filter will be use

 

example

Measure:

CityAQty =

var _qty = ROUND(CALCULATE(SUMX(FILTER(CityQty, CityQty[City]="A"), CityQty[Qty])),0)

return

maxx(values(CityQty[City]), calculate(  IF(DISTNICTCOUNT(CityQty[BranchType]) > 0, _qty,0) )

Jayaselvan's avatar
Jayaselvan
Helper II
4 years ago

Thanks for your response. 

To clarify, Change in filter doesn't impact the What If Parameter Upper bound right?

 

I have tried the code you have suggested which I mention below. The output of CityAQty is same if I view in the card with previos code I have used.

The Sum of total Quantity without filter is 250K. That's what taken as upper bound in What If paramter. 

But I need upper bound filter only for City A which is 18K. Is there is any way to achieve this. 

 

Measure:

CityAQty =

var _qty = ROUND(CALCULATE(SUMX(FILTER(CityQty, CityQty[City]="A"), CityQty[Qty])),0)

return

maxx(values(CityQty[City]), calculate(  IF(DISTNICTCOUNT(CityQty[BranchType]) > 0, _qty,0) )