cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Anonymous
Not applicable

## How to calculate one measurevalue against other

Hi,

I have following table:

 Costs Ist_Value Revenue 2345 Material Costs 117 Salary 189 Rent 378

I want to calculate ig. % of Material Cost based on Revenue

= ist_value / Revenue

My result should be following:

 Costs Ist_Value %Value Revenue 2345 100% Material Costs 117 4,90% Salary 189 8,06% Rent 378 16,12%

I try to extract the value for Cost=Revenue and use it for further calculation

Revenue =
CALCULATE(
SUMX(Table1,
Table1[Ist_Value]),
Table1[Costs] = "Revenue")

% Value =
DIVIDE(SUM(Table1[Ist_Value]),[Revenue])

But its always just showing % for Revenue:
 Costs Ist_Value Revenue % Value Revenue 2345 2345 100% Material Costs 117 Salary 189 Rent 378

What am I doing wrong?

1 ACCEPTED SOLUTION
Super User

Hi, @Anonymous

In that case, the situation has been changed to me.

So, I need to write the measure again from the beginning.

Please try the below and let me know whether it works.

Revenue =
CALCULATE (
SUMX ( 'Table', 'Table'[Ist_Value] ),
FILTER ( ALL ( 'Table' [Cost]), 'Table'[Costs] = "Revenue" )
)

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

4 REPLIES 4
Super User

Hi, @Anonymous

I think it is related to your Revenue measure.

Please try to replace it to the below.

Revenue =
CALCULATE (
SUMX ( 'Table', 'Table'[Ist_Value] ),
FILTER ( ALL ( 'Table' ), 'Table'[Costs] = "Revenue" )
)

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Anonymous
Not applicable

Hi Jihwan Kim,

It's almost correct.

Unfortunatly I wasn't 100% clear.

My original Table has also additionally a date inside:

(arggh I can't past Table)
Date   Costs  Ist_value

Jan     Revenue   2345

Jan    Material C   238

Feb    Revenue    5689

Feb    Material C  245

How can I still consider the date within Revenue calculation?

Right now with your approach it's taking total Sum of Revenue over whole table but it should be still grouped by date.

(sorry for not being accurate enough at the begining)

Super User

Hi, @Anonymous

In that case, the situation has been changed to me.

So, I need to write the measure again from the beginning.

Please try the below and let me know whether it works.

Revenue =
CALCULATE (
SUMX ( 'Table', 'Table'[Ist_Value] ),
FILTER ( ALL ( 'Table' [Cost]), 'Table'[Costs] = "Revenue" )
)

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Anonymous
Not applicable

Hi @Jihwan_Kim ,

Its working.

Announcements

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors