Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin 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.
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 |
|---|---|
| 8 | |
| 6 | |
| 3 | |
| 3 | |
| 3 |
| User | Count |
|---|---|
| 11 | |
| 9 | |
| 8 | |
| 7 | |
| 6 |