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!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
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
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the September 2025 Power BI update to learn about new features.
User | Count |
---|---|
9 | |
8 | |
8 | |
4 | |
3 |
User | Count |
---|---|
15 | |
15 | |
11 | |
10 | |
10 |