- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
POwer BI Matrix visual and DAX formula to add new column
Hello
I am trying to summurize in a matrix visual for each of suppliers how many part are shared among different plants and how many parts are not.
I have this raw data:
and below summary I would like to get in a matrix visual:
Thank you for your support
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Here is one way to do this:
I modified the example data a bit.
Note that this would be easier if you have a dimension table for parts and plants instead of one table.
Dax:
End result:
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
What's you issue? You just need to make 3 measure with distinctcount like this:
Measure1= distinctcount(table(plant served))
Measure2= distinctcount(table(part shared))
then you put the supplier column and the measure in a matrix or table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello Gabry,
If I do as you suggest, I will get the total count of Material by plant but I would like to have separetely the count of material that are shared to different plant.
Exampe material ABC from supplier 100 is common to plant A and B so resutl is 2, while DEF material from supplier 200 is commom to plants A B and C so the total is 3
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Here is one way to do this:
I modified the example data a bit.
Note that this would be easier if you have a dimension table for parts and plants instead of one table.
Dax:
End result:
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you so much it works!

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
07-04-2024 05:17 PM | |||
12-19-2023 08:03 AM | |||
02-15-2024 05:13 AM | |||
12-03-2023 07:43 AM | |||
11-10-2023 07:39 AM |
User | Count |
---|---|
14 | |
14 | |
11 | |
11 | |
8 |