cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
OrionTL
New Member

Perform a Count of each matrix subitem where it meets a criteria within another table

I have a matrix breaking down the categories of vehicle types and their subitem when "Expanded" based on TableA. I have a value column showing how many of those particular vehicle is on order based on the sum of TableB with all the order details. Both tables have a relationship based on a single unique column tying their Category-Subitem types. I'm trying to get the count of "how many orders were fulfilled" as shown on the last column of the picture of the table below 

 

TableA:

OrionTL_0-1670173074389.png

 

TableB:

OrionTL_1-1670173085928.png

 

Needed Output:

OrionTL_0-1670172492959.png

 

Thank you for your help!!

1 ACCEPTED SOLUTION
v-jianboli-msft
Community Support
Community Support

Hi @OrionTL ,

 

You can achieve this directly by using the data of TableB:

vjianbolimsft_0-1670204131042.png

Output:

vjianbolimsft_1-1670204146367.png

 

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
v-jianboli-msft
Community Support
Community Support

Hi @OrionTL ,

 

You can achieve this directly by using the data of TableB:

vjianbolimsft_0-1670204131042.png

Output:

vjianbolimsft_1-1670204146367.png

 

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.