Forum Discussion

Benc7777's avatar
Benc7777
Icon for Helper I rankHelper 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's avatar
    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.

Benc7777's avatar
Benc7777
Icon for Helper I rankHelper 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's avatar
fahadqadir3
Icon for Solution Supplier rankSolution 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.