Table Function - Need Help

[sandee]

Hello All,

I have data , where i have Due days. i want to create a measure that only show me days which is >=1 . 

Logic = FILTER('Table Aging,

Table Aging'[Days Due] >1)

but this i can not show in metrics table. since Filter function is a connector and will not show any result if using naked.

please advise ...

[Fowmy]

@sandee 

If you need a measure to count the record then: 

Logic = 
COUNTROWS(
FILTER(
    'Table Aging,
    Table Aging'[Days Due] >1
)
)

otherwise click on New Table in the modeling tab and paste

Logic Table = 

FILTER(
    'Table Aging,
    Table Aging'[Days Due] >1
)

[sandee]

Thank u Fowmy, it worked , but i got the complete table, what if i want one column only "Due Days >=1. should i use Value and Filter?