Forum Discussion
Solved
Vehicles with zero utilisation
I have a register of all assets that is linked to a transaction table which includes number of days on hire if relevant to transaction type. This is linked by the asset number. How do i extract asset...
Hi KleptoKenny
You can create the following measure, then add it to a visual as a filter and make it to show items when value is 0. In the visual, use [EQUIP_CODE] from 'Asset Table'.
No. of Sales = COUNTROWS(FILTER('Transaction table','Transaction table'[Trans Type]="Sales"))Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Hi KleptoKenny
You can create the following measure, then add it to a visual as a filter and make it to show items when value is 0. In the visual, use [EQUIP_CODE] from 'Asset Table'.
No. of Sales = COUNTROWS(FILTER('Transaction table','Transaction table'[Trans Type]="Sales"))
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Awesome thanks... Works great.