Forum Discussion
Avoid Recurring Value in Table
Hello, everyone. Sorry for interrupting your time, I'd like to ask a question. I'm dealing with the allocation resources problem and I'd like to visualize a summary in the table form. However, my table has redundant values. For example, the table below has redundant excess values "4", Materials "4E", and SourcePlace "B".
Redundant values
Is it possible to show the summary table in Power BI like the following table:
Please kindly find my attached PBI sample files through this link:
https://drive.google.com/file/d/17JuJsaD2yGODI9gNKrRq1SPDYjOACnMg/view?usp=sharing
I really appreciate your help and thanks to read this post.
Best regards,
Morran
6 Replies
Hi Morran ,
Just by looking at the screenshots, you might need to use a Matrix instead of a table visua but this may not be the case. Can you please explain your data model? For example, which ones are SourcePlace and Destplace and why there are different tables for the Excess when they have the same set of columns?
Hi danextian , thanks for responding this post.
So, if you've seen my PBIX file, SourcePlace is places which have the excess items. The amount of these excess items will be allocated to several places who need the items. For example, in the Deficit table, both B and C need "2G", which are "4" and "1"
After that, I want to explore another places that have an excess amount of this "2G". In this sample, only 1 place that have an excess, which is A. But in the reality, we have plenty source places that have an excess amount of this "2G" that need to be allocated to the shortage places.
Do have any ideas?It's similar with supply and demand model, where the "source" warehouse that have an excess amount will supply its units to the "target" warehouse, which is shortage. The idea is to express it using the above table and still thinking about the proper data model and DAX.
