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.
Good day Folks, Hope you're well!!
I'm not a DAX man and I'm in a situation where I need to subtract a Percentage from 1, here is what I have :
Event: A text Column Contains about 30 unique Values
OPE: A measure or equation: OPE = Deferral amount / [Deferral amount + Online Rate_MBD]
Online Rate_MBD: A column general value, summarization = Sum
Deferral amount: A coulmn with values
I have this measure :
My Data Now plotted as below :
I need to change the OPE to this equation : 1 - ( Deferral amount / [Deferral amount + Online Rate_MBD])
OR 1 - ([Deferral amount + Online Rate_MBD] / Online Rate_MBD)
If I just used
It seams that this happened becuse the value is more than 1 as below :
Is there are any Ideas to fix this issue please ?
Your help is highly appreciated guys..
Hello:
What about:
New Measure = 1 -[OPE]
and format as percent? Where OPE is a stand alone measure or variable.
Hello and thank you for your reply, unfortunately, I tried that already and the result is the same (
Hi:
Can you share some example data for the tables involved? We can miss a lot if we don't see the model,relationships,etc.. That could help get your answer. Thanks.
P.S. I would suggest the DIVIDE function vs / character.
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.
User | Count |
---|---|
10 | |
7 | |
5 | |
4 | |
3 |
User | Count |
---|---|
12 | |
11 | |
10 | |
9 | |
8 |