Forum Discussion

CupidC's avatar
CupidC
Icon for Helper II rankHelper II
3 years ago
Solved

Extract a single column from a Filter table on the fly

Hi everyone,   I need some help with optimizing my code for extracting a column from a filtered table on the fly. Currently, my code works, but I have a feeling that there might be a more straightf...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi CupidC 

    IYou can create a measure

    Measure = IF(SELECTEDVALUE('Customer Key'[Fruit])="Apple",1,0)

    Then you can use a table visual , put the key column to the visual, then put the measure to the visual filter

     

    Output

    Best Regards!

    Yolo Zhu

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

     

     

     

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi CupidC 

IYou can create a measure

Measure = IF(SELECTEDVALUE('Customer Key'[Fruit])="Apple",1,0)

Then you can use a table visual , put the key column to the visual, then put the measure to the visual filter

 

Output

Best Regards!

Yolo Zhu

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