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
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.
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 |