Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
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
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 9 | |
| 5 | |
| 4 | |
| 3 | |
| 3 |
| User | Count |
|---|---|
| 23 | |
| 12 | |
| 11 | |
| 9 | |
| 8 |