topic Re: Using data segmentation filter results in DAX calculation in DAX Commands and Tips

Using data segmentation filter results in DAX calculation

nix_ferreira — Mon, 17 Jun 2024 20:39:23 GMT

Hello!

I have a table that has data and one column (stock) that I use as a filter. This column only has null, 0 and 1 values. The thing is: I want to use this column in a data segmentation filter (like the one below), and reference whichever value the user chooses to filter in DAX defined columns for this same table, to create dynamic calculations. That is: I want to get the output of that filter and use it in DAX calculations.

The column I want to create would have this syntax:

new_column = CALCULATE( column_1 - column_2, stock = user_defined_stock )

where this variable here, `user_defined_stock`, is the output of the filter above (null, 0 or 1, or multiple selection if that's even possible).

How can I achieve this? I tried using SELECTEDVALUE for that, but I can't figure out how.

Re: Using data segmentation filter results in DAX calculation

Moetazzahran — Mon, 17 Jun 2024 23:29:26 GMT

Hello nix_ferreira,

You can create a variable with the name you specified and enclose the the slicer column you are using with the Selectedvalue (VAR)
Please try below.

new_column =
VAR user_defined_stock=SELECTEDVALUE(slicercolumn)

Return
CALCULATE( column_1 - column_2, stock = user_defined_stock )

Please let me know if it solves your requirement. If so, please accept it as a solution, and your kudo is much appreciated.

Re: Using data segmentation filter results in DAX calculation

nix_ferreira — Tue, 18 Jun 2024 12:06:26 GMT

Hi! That looks like would do the job, but how can I access the output of that data segmentation filter?

Re: Using data segmentation filter results in DAX calculation

Moetazzahran — Tue, 18 Jun 2024 12:18:34 GMT

Hello nix_ferreira,
What do you mean access the output of the data segmentation filter?
When you select the value on the slicer, it will automatically be stored as the variable you declared in the measure then it will calculate the value.
Can you please clarify?
Thank you

Re: Using data segmentation filter results in DAX calculation

Anonymous — Mon, 24 Jun 2024 07:32:52 GMT

Hi nix_ferreira ,

Any update on this? Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.

If these also don't help, please share more detailed information and description to help us clarify your scenario to test.

How to Get Your Question Answered Quickly

Regards,

Xiaoxin Sheng