Forum Discussion

v-xjiin-msft's avatar
v-xjiin-msft
Solution Sage
8 years ago

Hi Anonymous,

 

Zubair_Muhammad's solution should work for you.

 

Then based on your screenshot, it seems like you are creating a calculated column not a measure. Right? Please refer to following sample, and you can find out the difference between calculated column and measure. 

 

By the way, they are using the same expression:

 

 

Thanks,
Xi Jin.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

v-xjiin-msft not sure what I'm doing wrong:

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Community Champion
    8 years ago

    Anonymous

     

    Could you share your file?

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Zubair_Muhammad Unfortunately I don't think I can since my datasets contains company credentials to our CRM. What could be the issue is how the relationships are set up? Data from two different datasets are connected via a unique ID table and the security filter on both tables is set to 'Both'. The data I'm showing comes from two different places connected by the ID's highlighted: