Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. 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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
10 | |
10 | |
10 | |
9 | |
7 |
User | Count |
---|---|
17 | |
12 | |
11 | |
11 | |
10 |