I want to do subtraction and devide of (sum of assasible value - realization value)/sum of assasible

[deven11]

Gud morning

I have attached pbix file link for help

https://www.dropbox.com/scl/fi/7h3nuxc82jk5dbm3cwv5e/exa.pbix?rlkey=85011gizt2q6cmoq7ec2yhomo&st=d6h...

[anmolmalviya05]

Hi @deven11, Hope you are doing good.

To perform a calculation in Power BI that subtracts the realization value from the sum of assessable value and divides the result by the sum of assessable value, you can create a calculated measure using DAX (Data Analysis Expressions). Here's the DAX formula you can use:

MeasureName =
DIVIDE(
SUM(TableName[AssessableValue]) - SUM(TableName[RealizationValue]),
SUM(TableName[AssessableValue])
)

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

Let's Connect on LinkedIn: https://www.linkedin.com/in/anmol-malviya/?originalSubdomain=in

[selimovd · Accepted solution]

Hey @deven11 ,

at what point are you stuck or what did you try so far?

It should be easy, like:

Division Measure =
DIVIDE (
    SUM ( table1[assasible value] ) - SUM ( table2[realization value] ),
    SUM ( table1[assasible value] )
)

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic
Connect with me: LinkedIn