Getting error on Devide

[Anonymous]

Hello great people could you please help me to fix my error. As a new learer of Power BI, facing some basic difficulties. Appreciate your help. 

Progress measure = DIVIDE(CALCULATE(Table_query_Progress Status),[In scope Measure])

The syntax for 'Status' is incorrect. (DAX(DIVIDE(CALCULATE(Table_query_Progress Status),[In scope Measure]))).

I want to devide, Table_query_Progress Status this coloumn by In scope Measure. Unfrotunetly thhis coloumn, "Table_query_Progress Status)" is gray. 

Appreciate your help.

Thanks

[rohit_singh · Accepted solution]

Hi @Anonymous ,

You're getting the error beause in a measure you will need to specify an aggregation in order to reference a column.

Progress measure = DIVIDE(CALCULATE(MAX(Table_query_Progress Status),[In scope Measure])

Kind regards,

Rohit

Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 🙂

[Anonymous]

Appreciate your help. 🙂

[Anonymous]

Thanks. I have used that,

Progress measure = DIVIDE(CALCULATE(MAX(Table_query__1[Progress Status (If In-Progress)]),[In scope Measure])

getting this error:

Too few arguments were passed to the DIVIDE function. The minimum argument count for the function is 2.

[rohit_singh · Accepted solution]

Hi @Anonymous ,

This is because of missing brackets. Please ensure that you use tabs in your code to improve readability and troubleshooting time.

Progress measure =

DIVIDE(
        CALCULATE(
                  MAX(Table_query__1[Progress Status (If In-Progress)])
        ),
[In scope Measure]
)

Kind regards,

Rohit

[Anonymous]

Thank you. Appreciate your help. 🙂

[rohit_singh · Accepted solution]

Hi @Anonymous ,

You're getting the error beause in a measure you will need to specify an aggregation in order to reference a column.

Progress measure = DIVIDE(CALCULATE(MAX(Table_query_Progress Status),[In scope Measure])

Kind regards,

Rohit

Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 🙂