Could you please attach your packaged workbook.
And from a quick look of your description for option 2, try to change the filter to "context" for LOD to work appropriately.
That might be the thing.
Thank you Shin , for quick response.
In the dashboard, I have two reports , one is which I want to change from bar to water fall and it has 13 filters and one parameter so that user can enter any value.
I am not clear on how or where I can apply context filter.
Is there any other way/alternative to replicate Field builder /to use index() .
I cannot attach the workbook and i will try to replicate and send if possible.
Seeing data is the most reasonable way.
Speculating everything is VERY inefficient.
Please mock up data and attach packaged workbook.
You are absolutely right.
I am new and it looks complex. I will try to get the data and workbook in sometime.
I am attaching sample data which does not make much sense and the workbook.
It is a bar chart and I need to change it as waterfall.
The challenge i face is summing them and in size mark.
calcuated fields of measures are as below:
M2 = M1 * PARAMETER
M3 = M1 *M2
M4 = M2 + M3
M5 = M4+ M1
Please let me know if details are not clear.
Appreciate quick reply.
WF_multimeasures.twbx 12.3 KB