Forum Discussion
create a (calculated)column based on a selection with a unique value
You misunderstood my solution. In Step 1 I said "Create a new Table" NOT a new Column. The whole example will add the value in a table visual, not in your dataset.
In other words, with my solution you create a selectable measure that you add to a visual Table or a Table matrix together with column from your dataset.
I hope it makes sense now.
I'm sorry I explained this not good enough. I did made a table:
Then: measure:
Then:
on the data-table where I need the column I add this column based on the measure:
I hope I explained it right?
We are spinning in circles 🙂 Your screenshot with the table is from your Table view and my solution is applicable in the Report view (see the attached screenshots).
Ahhh well then this solution is not applicable for me. I want to add a column in the table and not in the report. I have already made a parameter (see already send picture second column on the right 'uurselectie'). But the thing is that in Tableau you can use a parameter as a column in the table and change it via a selection, in powerBI you can add the parametervalue in the table, but here you can not change the parameter value via een slicer/ selection in the view.
Many thanks for you time I appreciate thisI think Tableau is mixing things up a bit. In PowerBI you do the selection at Report level not at dataset level (or at least not that I'm aware of).
Cheers