Forum Discussion

NJ81858's avatar
NJ81858
Helper IV
3 years ago

User Entered Value Across All Pages

Hello,   I have a report that is contingent on users entering in a value for all of my calculations. What is the best way to achieve this? It has to span multiple pages and I would prefer the user ...
Need Help
NJ81858's avatar
NJ81858
Helper IV
3 years ago

pratyashasamal When I create my What-If Parameter, I also create a measure to combine all of them, as my final value will always be bigger than 100,000, and doing this in intervals of 1 causes problems for my data.

 

I created 7 different What-If Parameters all with ranges from 0 to 9, so I am covered in any value from 0 to 9,999,999, and then my measure to combine them is:

Final Value = FORMAT((SELECTEDVALUE('Million'[Million])*1000000) +
(SELECTEDVALUE('Hundred Thousands'[Hundred Thousands])*100000) +
(SELECTEDVALUE('Ten Thousands'[Ten Thousands])*10000) +(SELECTEDVALUE('Thousands'[Thousands])*1000) +
(SELECTEDVALUE('Hundreds'[Hundreds])*100) + 
(SELECTEDVALUE('Tens'[Tens])*10) + 
(SELECTEDVALUE('Ones'[Ones])), "Currency")

 

This measure is being invoked on Calculated Columns, and even when I copy my slicers to the report pages, it gives me the following error even though the measure works on the given page:

 

pratyashasamal's avatar
pratyashasamal
Memorable Member
3 years ago

Hi NJ81858 ,
Try to check if all the what if Parameter are having the correct data type i.e. Numeric data type.
Looks like issue is due to this.
Thanks,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C