Forum Discussion

p_kaushal's avatar
p_kaushal
Frequent Visitor
9 years ago
Solved

create %share measure with repeated column value

Sample of my data]-The Total Base actually comes from a small table with year weekno and total base column which I create a relationship on year week no   yearweekno region Format Sales TY S...
Need Help
  • p_kaushal's avatar
    p_kaushal
    9 years ago

    Sorry for the late reply!

     

    I was able to solve the issue.The issue was not related to the formulas but it was related to the data connections and relationships between my tables which I had made between tables which was duplicating the dimension metric and hence max(base) was changing.

     

    Thanks for looking into it though.Much appreciated.

v-ljerr-msft's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi p_kaushal,

 

Yes, a little weird. Could you share a sample pbix file which can reproduce the issue? So that I can help further investigate on this issue. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.:smileyhappy:

 

Regards

p_kaushal's avatar
p_kaushal
Frequent Visitor
9 years ago

Sorry for the late reply!

 

I was able to solve the issue.The issue was not related to the formulas but it was related to the data connections and relationships between my tables which I had made between tables which was duplicating the dimension metric and hence max(base) was changing.

 

Thanks for looking into it though.Much appreciated.