Forum Discussion

martipe1's avatar
martipe1
Helper II
2 years ago

Use Measure from one table in another table

Ashish_Mathur did help me, thanks again, in creating a measure for a moving average for forecast in my table KMR, now I want to use that measure in another visual that uses a diferent table (IWI) to calculate inventory coverage.

 

For example, for a specific product in May I have an average forecast of 82, if for that item my inventory is  200, how can I use that measure to get my inventory coverage (200/82)=2.44, when I move in time and in June I have 101 for average and an inventory of 250 my coverage should be (250/101)= 2.48

 

Thanks in advance for your help.

Need Help
Show and Tell

6 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    You can use measures as filters in visuals.

     

    While measures do have a "home table"  that is meaningless. Measures don't care about where they are stored.

    • martipe1's avatar
      martipe1
      Helper II
      2 years ago

      Thank you very much for your answer, lbendlin.

      That would be great, unfortunately, when I create a slicer and try to add the measure it doesn't allow me.

      Thanks!

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    2 years ago

    Hi,

    Share data in a format that can be pasted in an MS Excel file.  Show the expected result.

    • martipe1's avatar
      martipe1
      Helper II
      2 years ago

      Hi, Ashish_Mathur .

       

      Thank you very much for you answer.

      Here it is an excel file I hope it can be of use. Inventory Coverage Excel File 

      It's just a small example of the measure you created (tamble KMR) and how I want to use it in another visual using a different table (IWI)

      If you need a different excel file or you need I elaborate on what I expect as an end result, please let me know.

      Thanks!!