Use Measure from one table in another table

Question

Ashish_Mathur&nbsp;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.&nbsp;For example, for a specific product in May I have an average forecast of 82, if for that item my inventory is&nbsp; 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&nbsp;Thanks in advance for your help.

lbendlin · Answer

You can use measures as filters in visuals.
&nbsp;
While measures do have a "home table"&nbsp; that is meaningless. Measures don't care about where they are stored.

ashish_mathur · Answer

Hi,
Share data in a format that can be pasted in an MS Excel file.&nbsp; Show the expected result.

martipe1 · Answer

Hi,&nbsp;Ashish_Mathur&nbsp;.&nbsp;Thank you very much for you answer.Here it is an excel file I hope it can be of use. Inventory Coverage Excel File&nbsp;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!!

martipe1 · Answer

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 · Answer

There's absolutely nothing i can understand there.

Forum Discussion

Related content

Cumulative Difference from Another measure

Filter measure by another measure

Power Query LookUp in another table

Use measures from another semantic model

[PowerQuery] add (same) column from another table