topic Table Function - Need Help in DAX Commands and Tips

Table Function - Need Help

sandee — Fri, 28 May 2021 12:43:42 GMT

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 — Fri, 28 May 2021 12:52:16 GMT

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 — Fri, 28 May 2021 13:02:16 GMT

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?