Forum Discussion

YehudaBI's avatar
YehudaBI
New Member
4 years ago

Filtering a column that created from two columns?

Hi Community, I have a column (XY FILE) that I made by adding two columns (X file + Y file). I want to filter that column by X file or Y file, but when I do that it filters it wrong.   X file  | ...
VahidDM's avatar
VahidDM
Icon for Super User rankSuper User
4 years ago

Hi YehudaBI 

 

If there are only 1 and 0 in X and Y file columns, try this measure:

Measure = countrows(table)

 

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

 

 

  • YehudaBI's avatar
    YehudaBI
    New Member
    4 years ago

    Hi VahidDM,

    Maybe I didn't explain myself right.

    I Have another Column that I'm filtering X or Y with it.

    I need a measure that:

    - If nothing is Filtered: it sums the XY file column

    - if X file is filtered: it sums just the X file column

    - if Y file is filtered: it sums just the Y file column

     

    I hope this time I explained myself well.

    Thank you!