cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.