Forum Discussion
Create a comparison column using 3 tables
Dear All, I am working on a report that I need your help and ideas. I have 3 tables that I am working on direct query mode to create report. These 3 tables looks like simply as below in terms...
Hi, metin
Can share more details for testing?
Perhaps your measure lacks the corresponding context for filtering in the current visual object. If so, you may need to use the “summarize“ function to create a temporary table for encapsulation before using the measure.
Best Regards,
Community Support Team _ Eason
There @v-easonf-msft
I have created a sample data set but not sure how I can share it with you.
The measure I am using in each table (Inventory, Order and GIT) simply looks like below;
Total By Material Number (INV) = CALCULATE (SUM (Inventory [Quantity Available]), GROUPBY (Inventory, Inventory [Product Code]))
Then I had another measure like this to show the gap.
Measure = Total By Material Number (Order) - Total By Material Number (INV) - Total By Material Number (GIT)
I can see end result of this formula when I put in table type of visual.
However I want to create a couple pie chart type of visuals which would show the percentage of products which have excess or minus stock. Above measures doesn't help to create such a visual.
Let me know if you need further details.
Thanks.