Forum Discussion

nix_ferreira's avatar
nix_ferreira
Regular Visitor
2 years ago

Using data segmentation filter results in DAX calculation

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...
Need Help
Tips and Tricks
Tutorial Requests
Moetazzahran's avatar
Moetazzahran
Resolver II
2 years ago

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.

nix_ferreira's avatar
nix_ferreira
Regular Visitor
2 years ago

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

  • Moetazzahran's avatar
    Moetazzahran
    Resolver II
    2 years ago

    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