Forum Discussion
Use parameter value for calculation using selected value
Hi,
Using the code below I get a result based on a calculation with the number 120000000.
In stead of that I tried using SELECTEDVALUE but no result.
Any help would be appreciated.
Cheers,
Herman
4 Replies
Hi Anonymous
If I understand your question correctly, you want to replace the 120000000 with a what if parameter?
If so you can create a What-If parameter and use the parameter value measure that is generated when you create the what if parameter in your calculation.
It will look something like this:
AandeelPerProduct =ADDCOLUMNS(CROSSJOIN( DISTINCT(dDate[FMaand]), VALUES(fCategories[PROD_Name])),"Revenue",CALCULATE([Omzet],dDate[Fiscaal Jaar] = 2022),"Pct",DIVIDE(CALCULATE([Omzet],dDate[Fiscaal Jaar] = 2022), CALCULATE([Omzet],dDate[Fiscaal Jaar] = 2022,ALL(fTransactions)))*[Parameter Value])I hope this is what you are trying to achieve.HughHi Hugh!
Thanks for your reply. I was thinking the same so I created a series of parameters like:
Budget = GENERATESERIES(110000000, 130000000, 500000) and putting these in a slicer. I expected that using SELECTEDVALUE on this would work, but it doesn't. I tried INT as well to change it to a number, but to no avail.Any other thoughts?Cheers,HermanHi Herman
When put the measure in a card visual does it show you selected value?
Like this:
Can you maybe also share your selected value measure?
Regards
Hugh
