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  | ...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

YehudaBI , what do mean by filter by X file

Are you trying a measure like

countrows(filter(Table, Table[X file] <> 0 ))

  • YehudaBI's avatar
    YehudaBI
    New Member
    4 years ago

    Hi  Amitchandak,

    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!