Extracting counts of a Measures from a Matrix to disconnected table
-
- Posts: 8
- Joined: Fri Jun 19, 2020 6:26 am
Extracting counts of a Measures from a Matrix to disconnected table
I have a data table with currently 200 yield measurements. In the attached file the matrix on the left has 50 rows where each row is a joint that has >= 1 yield measurement. Fast Grade is a measure. I want to summarize by count Fast Grade into a disconnected table shown as Cat Count that has 11 levels. I have not been successful. All my extractions come out in terms of the yields and total 200 instead of the desired 50 joints. Thanks in advance for any help. Best, Bill Harper
- Attachments
-
- To share, Fast Grade_v45h2.pbix
- (196.84 KiB) Downloaded 13 times
-
- Posts: 1150
- Joined: Sun May 04, 2014 4:01 pm
- Location: Sydney, Australia
Re: Extracting counts of a Measures from a Matrix to disconnected table
So i think this is resolved now Bill, right?
Matt Allington is Self Service BI Consultant, Trainer and Author of the Book "Supercharge Power BI".
Power BI Training
Power BI Training
-
- Posts: 8
- Joined: Fri Jun 19, 2020 6:26 am
Re: Extracting counts of a Measures from a Matrix to disconnected table
Matt, Oui, Yes, YES.
Thanks so much, Bill
Thanks so much, Bill
Who is online
Users browsing this forum: No registered users and 1 guest