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...
There @v-easonf-msft,
It is not fully solved. I have been able to create a measure to show the gap between "order, inventory and GIT" however I can't convert it to a another measure or column using IF fucntion.
First I have calculated each tables value seperately with below measure.
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)
Up to here, it is working very well. I could create table as I would like.
My problem continues as follows. I would like to create an executive summary (pie chart or summary table) showing the percentage of orders (per value and quantity).
Therefore I tried to create a new measure with some IFs to convert the final measure into some text values like (if measure is below zero it will say "Not Available", or if it is above 0 and below 10, "Critical", and if above 10 "Available".
However this final measure with IFs is not working (not sure why) in the visuals. It is showing everything in the same bucket.
This is the problem I have at the moment.
Hi , metin
Pbix files in live conect mode are not suitable for sharing. It is recommended to paste the simplified tables' data here, then please briefly introduce the relationship between tables and your expected results.You also can upload a simplified version in import mode to Onedrive and share the link here.
Best Regards,
Community Support Team _ Eason