Forum Discussion

Oros's avatar
Oros
Icon for Post Prodigy rankPost Prodigy
5 years ago
Solved

Divide a column by a measure

Hello.   I divide a column (from a table) by a measure (from another table) and it does not seem to be working.  Some rows work but most do not divide well. Inventory divided by Sales per week.   ...
Need Help
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    I assumed you had other columns in your table visual.  Is that the case?  Either way, I'm sure you already put that back to Don't Summarize.  What are those columns?  And how do the table(s) they are from relate to your other tables?  More info about your model is needed to troubleshoot further.  The default aggregation was potentially a quick fix (that didn't work).

     

    Pat

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

I assumed you had other columns in your table visual.  Is that the case?  Either way, I'm sure you already put that back to Don't Summarize.  What are those columns?  And how do the table(s) they are from relate to your other tables?  More info about your model is needed to troubleshoot further.  The default aggregation was potentially a quick fix (that didn't work).

 

Pat

Oros's avatar
Oros
Icon for Post Prodigy rankPost Prodigy
5 years ago

Hi mahoneypat ,

 

Thank you so much.  I checked the table relationships and pulled the product number from a related table and everything works now.  Thanks again.