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])="Active",
        SUMMARIZE( 'Cost Element', 'Cost Element'[Item Number]),
        CALCULATE( SUM( 'Cost Element'[Unit Cost] ) ) = 0.00000
    )
)
 
I am getting a Synatax error for line:'Cost Element','Cost Element'[Item Status])="Active",
 
What am I doing wrong?
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)
    )

1 Reply

  • 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)
    )