Forum Discussion

mehupbi's avatar
mehupbi
Frequent Visitor
2 years ago
Solved

On Selection, values are not changing calculated column value

Here is my PBIX file https://filetransfer.io/data-package/hhXShkwY#link

I have parametered table and main table. I kept the parametered table values in slicer and created calculated column to switch value with conditional logic.

plant_and_name =
  VAR SelectedViewValue = [SelectedView]
  RETURN
     IF (
        SelectedViewValue = "sample",
        [plant_country],
        [plant_name]
    )
 
Note working. Please help me 
Need Help
Show and Tell
Tips and Tricks
  • PijushRoy's avatar
    PijushRoy
    2 years ago

    Hi mehupbi 

    I have created a measure and it is perfectly working. Please find the measure and update the measure logic if needed.


    Please find the PBIX file


     


    Let me know if that works for you


    If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.

    Thanks
    Pijush
    Linkedin

1 Reply

  • PijushRoy's avatar
    PijushRoy
    Icon for Community Champion rankCommunity Champion
    2 years ago

    Hi mehupbi 

    I have created a measure and it is perfectly working. Please find the measure and update the measure logic if needed.


    Please find the PBIX file


     


    Let me know if that works for you


    If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.

    Thanks
    Pijush
    Linkedin