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.
Hi,
I'm trying to understand variable usage and tried creating the mesaure below however, when put into a table the result is true/false as opposed to value.
Please can you explain where i'm going wrong and if my logic is flawed.
Measure is below the Target% measure is a %
Solved! Go to Solution.
@OsmanEmi , this can be like
Scoring System =
var CurrentScore = 0
Return IF(Target[Target%] > 0.98, CurrentScore + 0, CurrentScore + 1)
but are you expecting looping that will not happen
@OsmanEmi , this can be like
Scoring System =
var CurrentScore = 0
Return IF(Target[Target%] > 0.98, CurrentScore + 0, CurrentScore + 1)
but are you expecting looping that will not happen
Hi Amit,
Thank you this was what I was looking for.
In terms of if I wanted to create a nested if that adds more to the variable would this still work?
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.