Forum Discussion

craig811's avatar
craig811
Icon for Helper III rankHelper III
5 years ago
Solved

Easy DAX formula what am I missing?

Hi all,   Sorry this should be a simple formula to show uncosted transactions that are 'Active'   Uncosted Transactions = COUNTROWS(     FILTER('Cost Element','Cost Element'[Item Status])="Ac...
Need Help
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    5 years ago

    craig811 , Try like

    Uncosted Transactions =
    COUNTROWS(
    FILTER('Cost Element','Cost Element'[Item Status])="Active",
    && ( isblank( 'Cost Element'[Unit Cost] ) || 'Cost Element'[Unit Cost] =0.0000)
    )

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

craig811 , Try like

Uncosted Transactions =
COUNTROWS(
FILTER('Cost Element','Cost Element'[Item Status])="Active",
&& ( isblank( 'Cost Element'[Unit Cost] ) || 'Cost Element'[Unit Cost] =0.0000)
)