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

[mahsan_ojaghian]

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

[mahsan_ojaghian]

Hi.

Thank you for your response.<3

[v-mengzhu-msft · Accepted solution]

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

[Jihwan_Kim]

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]

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.