Easy DAX formula what am I missing?

[craig811]

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?

[amitchandak · Accepted solution]

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