Forum Discussion

mahsan_ojaghian's avatar
mahsan_ojaghian
Icon for Helper I rankHelper I
4 years ago
Solved

Dynamic value Changing in Calculate Column With Slicer Filter On Report Page

Hi Guys!

I have a calculate column that consists of sum of  two parameters.

one of them is constant and the other one shoud be variable and changes with

slicer filter On Report Page.

What should I do for reaching True result??

Thank You All.πŸ€—

  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi mahsan_ojaghian οΌŒ

     

    The slicer or filter can’t active with calculate column. You can use measure to complete your idea, as the following shows, is that result you want to achieve? When I filter the values in the variable table, the sum measure created will change with it.

     

    For example, now I choose β€œ5”:

     

    Then I choose β€œ3”, it followed the changes that occurred:

    You can try this measure:

    sum = SUM('Table 1'[constant])+ SELECTEDVALUE('variable table'[variable])

     

    and this is my testing file , hope it finds you well.

     

    Best regards,

    Community Support Team Selina zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

4 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Icon for Super User rankSuper User
    4 years ago

    Hi,

    If you have an option to create a measure, instead of creating a calculated column, please try creating a measure and put it into a visualization. And then it will suit to your requirement.

    Please share your sample pbix file's link (Onedrive, googledrive, or dropbox, or others.....) here, and then I can try to look into it to come up with writing a measure.

     

    Thanks.

    • mahsan_ojaghian's avatar
      mahsan_ojaghian
      Icon for Helper I rankHelper I
      4 years ago

      Hi Mr,Kim.

      Thanks for your response.

      But I can't use a measure for my calculation because I need more calculations after this step.

      And unfortunately can't share my pbix file with you cause my workplace doe'nt allow me to share.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi mahsan_ojaghian οΌŒ

     

    The slicer or filter can’t active with calculate column. You can use measure to complete your idea, as the following shows, is that result you want to achieve? When I filter the values in the variable table, the sum measure created will change with it.

     

    For example, now I choose β€œ5”:

     

    Then I choose β€œ3”, it followed the changes that occurred:

    You can try this measure:

    sum = SUM('Table 1'[constant])+ SELECTEDVALUE('variable table'[variable])

     

    and this is my testing file , hope it finds you well.

     

    Best regards,

    Community Support Team Selina zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly