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

Microsoft Employee

## Does not recognize the measures even through it is there

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.

2 ACCEPTED SOLUTIONS
Super User

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
Microsoft Employee

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)
5 REPLIES 5
Microsoft Employee

here is the screen shot of the error message

Microsoft Employee

I have them all in the measures table

Microsoft Employee

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)
Super User

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
Microsoft Employee

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

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.