Forum Discussion

Helper I

2 years ago

Solved

Create a measure usin a measure ?

Hi There, I have created a measure No. Orders = CALCULATE(COUNTROWS(Query1),FILTER(Query1,Query1[State]="O")) Which works fine I Now would like to create a measure using this and anot...

Need Help

fahadqadir3
2 years ago
Benc7777 When using measure in a calculation no need to write table name, also remove the table name 'Query1'.

Percentage2 = DIVIDE(SUM('Query1'[Late Order]),[No. Orders],0)
Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.

fahadqadir3

Solution Supplier

2 years ago

Benc7777 No need to use SUM before measure. Percentage 2 should be:

Percentage2 = DIVIDE(SUM('Query1'[LateOrder]),
                    ('Query1'[No.Orders]))

In my example, i'm using 2 different tables and it works fine.

No. Orders = CALCULATE(COUNTROWS('Table 1'))

Percentage = DIVIDE(SUM('Table 2'[Value]),[No. Orders],0)

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.

Benc7777

Helper I

2 years ago

Thanks for the reply,

But I still get an error (Below)

'Query1'[LateOrder] - Is a table

No.Orders is a measure.

fahadqadir3
Solution Supplier
2 years ago
Benc7777 When using measure in a calculation no need to write table name, also remove the table name 'Query1'.

Percentage2 = DIVIDE(SUM('Query1'[Late Order]),[No. Orders],0)
Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.
- Benc7777
  Helper I
  2 years ago
  It worked , always really appriciate help on here, i really do !
  
  Thanks