-
1. Re: changing the measure value using parameter having 90+values
Zhouyi ZhangJan 9, 2018 10:39 PM (in response to Anjali Singh)
Hi, Anjali
How is your data looks like? Does your currency value in column level or in Row level?
If it is column level, you may try pivot the data, or if it is row level, then drag currency column to filter
It will be helpful if you could provide sample data or workbook.
ZZ
-
2. Re: changing the measure value using parameter having 90+values
Anjali Singh Jan 9, 2018 11:34 PM (in response to Zhouyi Zhang)Hi Zhouyi,
The currency is not present in data. I need to create a parameter for it.
Thanks,
Anjali
-
3. Re: changing the measure value using parameter having 90+values
Zhouyi ZhangJan 10, 2018 4:58 AM (in response to Anjali Singh)
Please share a sample data or sample workbook, otherwise, it is not helpful to look into your question
ZZ
-
4. Re: changing the measure value using parameter having 90+values
Anjali Singh Jan 10, 2018 6:04 AM (in response to Zhouyi Zhang)Hi Zhouyi,
Please see attached the sample file. I have to add more 90 values for currency type in the parameter. In that case apart from using if else block, is there any way to calculate the sales value which will change with changing parameter selection.
Thanks!
-
testCurrency Parameter.twbx 1.2 MB
-
-
5. Re: changing the measure value using parameter having 90+values
Zhouyi ZhangJan 11, 2018 4:05 AM (in response to Anjali Singh)
Hi, Anjali
Please find my solution attached and below is the screenshot of steps
Hope this could help
ZZ
-
testCurrency Parameter.twbx 1.1 MB
-