Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
User | Count |
---|---|
25 | |
12 | |
8 | |
6 | |
6 |
User | Count |
---|---|
26 | |
12 | |
12 | |
10 | |
6 |