Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
I'm very new to BI and measure creation, so please bear with me. I have a measure I created to calculate the difference between two column amounts based on the column date.
In some of those colums there are (blank) spaces or null in place of 0's. How do I update my current measure to replace null with 0?
I've tried transforming the data first (to bypass needing to create a measure), but for some reason it still only shows up as blanks spaces in my data.
Please see below.
@irishtate Perhaps:
Difference =
VAR __Diff =
IF (
HASONEVALUE ( 'AP_Transactions'[PerPost] ),
BLANK (),
CALCULATE (
SUM ( 'AP_Transactions'[TranAmt] ),
FILTER ( 'AP_Transactions', 'AP_Transactions'[PerPost] = MAX ( 'AP_Transactions'[PerPost] ) )
)
- CALCULATE (
SUM ( 'AP_Transactions'[TranAmt] ),
FILTER ( 'AP_Transactions', 'AP_Transactions'[PerPost] = MIN ( 'AP_Transactions'[PerPost] ) )
))
RETURN
__Diff + 0