Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Medo
Frequent Visitor

Subtracting a Percentage from 1 in DAX

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

Medo_0-1649253971914.png

 

Deferral amount: A coulmn with values 

Medo_1-1649254134455.png

 

I have this measure : 

deferral+online rate = SUMX(vw_ROO_Reporting_Losses,vw_ROO_Reporting_Losses[Deferral Amount]) + SUMX(tbl_OnlineSummary,tbl_OnlineSummary[Online Rate_MBD])

 

My Data Now plotted as below : 

Medo_2-1649255005703.png

Medo_3-1649255210489.png

 

 

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 

1- DIVIDE(SUM(vw_ROO_Reporting_Losses[Deferral Amount]), [deferral+online rate])

it's showing that 

Medo_4-1649255333574.png

It seams that this happened becuse the value is more than 1 as below : 

Medo_5-1649255595813.png


Is there are any Ideas to fix this issue please ?

 

Your help is highly appreciated guys.. 

3 REPLIES 3
Whitewater100
Solution Sage
Solution Sage

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.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.