Forum Discussion

harshagraj's avatar
harshagraj
Icon for Post Partisan rankPost Partisan
4 years ago
Solved

Slicer value in calculated column

Hello all how do i assign a dynamic slicer value on a calculated column. Please see the attached. I cant create a measure for this. Kinldy help. I just need to display 1 for the selected value...
Need Help
  • Avantika-Thakur's avatar
    Avantika-Thakur
    4 years ago

    Hi harshagraj ,

    As you are using a calculated column, we cannot use the selected value from segment code slicer in the DAX for calculated column as calculated columns work on row by row calculation and tend to give static values in each row of the table.
    You might need to create a measure for dynamic filtering of the segment code in the DAX.

     

    Thanks!

    Avantika

Avantika-Thakur's avatar
Avantika-Thakur
Icon for Solution Supplier rankSolution Supplier
4 years ago

Hi harshagraj ,

As you are using a calculated column, we cannot use the selected value from segment code slicer in the DAX for calculated column as calculated columns work on row by row calculation and tend to give static values in each row of the table.
You might need to create a measure for dynamic filtering of the segment code in the DAX.

 

Thanks!

Avantika

  • harshagraj's avatar
    harshagraj
    Icon for Post Partisan rankPost Partisan
    4 years ago

    Hi Avantika-Thakur thanks for the reply but the problem is cant able to create a measure for this too.I cant aggregate Segment code column.

    IF(_??__(SegmentCode) =Selectedvalue(Segmentcode),1,0)