Does not recognize the measures even through it is there

[IshPradhan]

I have two measure and they work by themselves.

CPS_UniqueMPNIDv2 = DISTINCTCOUNT(SQL_PartnerStatusReport[PartnerMPNID])

CPS_TotalNominationCount = SUM(SQL_PartnerStatusReport[NominationCount])

When I divide one with the other to get a average,

AverageEarningsPerUniquePartnerCount = DIVIDE(CPS_TotalNominationCount, CPS_UniqueMPNIDv2, 0)

I get the message 'CPS_TotalNominationCount'. It is not a valid table, variable, or function name. It highlights both measures actually.

Appreciate your help. Thanks

[Anand24 · Accepted solution]

Hi @IshPradhan ,
Are both of these calculated measures or calculated columns? The 3rd measure you are creating, is it also a calculated measure or calculated column?
Please share a screenshot of error message.

Also, please try to enclose the measure names within square brackets once

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! LinkedIn

[IshPradhan]

here is the screen shot of the error message

[IshPradhan]

I have them all in the measures table

[IshPradhan · Accepted solution]

I figured it out. Had to reference the measure by providing the Measure table name. This worked. Thanks for pointing me in the right direction.

AverageEarningsPerUniquePartnerCount = DIVIDE(MCAP_Measures_Calcs[CPS_TotalNominationCount], MCAP_Measures_Calcs[CPS_UniqueMPNIDv2], 0)

[Anand24 · Accepted solution]

Hi @IshPradhan ,
Are both of these calculated measures or calculated columns? The 3rd measure you are creating, is it also a calculated measure or calculated column?
Please share a screenshot of error message.

Also, please try to enclose the measure names within square brackets once

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! LinkedIn

[IshPradhan]

both of these are calculated measures, the third one is also a calculated measure and the uses the first two measures