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,

 

According to your description above, I have tested it with your sample data and the formulas. I am not sure I can reproduce your issue. It seems to work all fine for me.

%Share = 
 ( SUM ( 'Table1'[Sales TY] ) - SUM ( 'Table1'[Sales LY] ) )
    / MAX ( 'Table2'[Total Base] )

Here is the sample pbix file for your reference.:smileyhappy:

 

Regards

p_kaushal's avatar
p_kaushal
Frequent Visitor
9 years ago

Thanks for having a look.Yes, that's how it should work.Somehow the total row % share doesn't show correct values in my Power BI.

 

It's a weird error !

 

  • 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.