Forum Discussion

enthousiastnick's avatar
enthousiastnick
Frequent Visitor
2 years ago

create a (calculated)column based on a selection with a unique value

Hi, I have a column 'hours' that needs to be fild with a unique value .i.e. '18' for all records, regardless the other columns. So every record needs to be 18 And with a slicer i want to change th...
Need Help
enthousiastnick's avatar
enthousiastnick
Frequent Visitor
2 years ago

In my dataset i made a new column (as you suggested) named test = [Selected_value], default = 0;
The result is that only the default is shown, and using the slicer value stays 0

 

 

  • MNedix's avatar
    MNedix
    Solution Sage
    2 years ago

    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.

    • enthousiastnick's avatar
      enthousiastnick
      Frequent Visitor
      2 years ago

      I'm sorry I explained this not good enough. I did made a table:

      Then: measure: 

      Selected_value = SELECTEDVALUE('24_hour_tabel'[uren], 0)
      Then:
      slicer, based on table;

      Then:

      on the data-table where I need the column I add this column based on the measure:

       

      I hope I explained it right?

       

      • MNedix's avatar
        MNedix
        Solution Sage
        2 years ago

        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).