Forum Discussion

HeideDeLange's avatar
HeideDeLange
Regular Visitor
1 year ago
Solved

Data validation - dependency hierarchy without creating Data lists

Hi all, I need some help. I have a list of Brokerages and Branches and I am creating a form where the user chooses the Brokerage and then must choose a branch. I only want the branches belonging to ...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi HeideDeLange 

    Of course you can! You can use the SELECTEDVALUE( ) function to get the result of the slicer selection.

    Test = SELECTEDVALUE('Table'[Brokerage])

     

    Put this measure in the card visual to validate the results:


     

     

     

     

     

     

    Best Regards,

    Jayleny

     

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

HeideDeLange's avatar
HeideDeLange
Regular Visitor
1 year ago

Hi there, 

Thanks, I learnt something new today, but the slicers don't work, unless you can help with the next step.

So selecting the data was one thing, then I use the result of the selection in a vlookup to bring back a data point. 

Can I reference the slicer selection in a vlookup formula?

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi HeideDeLange 

Of course you can! You can use the SELECTEDVALUE( ) function to get the result of the slicer selection.

Test = SELECTEDVALUE('Table'[Brokerage])

 

Put this measure in the card visual to validate the results:


 

 

 

 

 

 

Best Regards,

Jayleny

 

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