Skip to main content
cancel
Showing results for 
Search instead 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

Reply
IshPradhan
Microsoft Employee
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.

Appreciate your help. Thanks

2 ACCEPTED SOLUTIONS
Anand24
Super User
Super User

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

PBI_SuperUser_Rank@1x.png  

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

View solution in original post

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)

View solution in original post

5 REPLIES 5
IshPradhan
Microsoft Employee
Microsoft Employee

here is the screen shot of the error message

IshPradhan_1-1679939794174.png

 

IshPradhan
Microsoft Employee
Microsoft Employee

I have them all in the measures table

IshPradhan_0-1679939698687.png

 

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

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

PBI_SuperUser_Rank@1x.png  

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

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.