Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi all,
Sorry this should be a simple formula to show uncosted transactions that are 'Active'
Solved! Go to 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)
)
@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)
)
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
112 | |
90 | |
83 | |
76 | |
64 |
User | Count |
---|---|
144 | |
109 | |
108 | |
100 | |
96 |