Extracting counts of a Measures from a Matrix to disconnected table

Anything related to PowerPivot and DAX Formuale
WilliamHarper
Posts: 8
Joined: Fri Jun 19, 2020 6:26 am

Extracting counts of a Measures from a Matrix to disconnected table

Postby WilliamHarper » Wed Oct 21, 2020 10:15 am

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

MattAllington
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

Postby MattAllington » Thu Oct 22, 2020 3:21 pm

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

WilliamHarper
Posts: 8
Joined: Fri Jun 19, 2020 6:26 am

Re: Extracting counts of a Measures from a Matrix to disconnected table

Postby WilliamHarper » Thu Oct 22, 2020 10:58 pm

Matt, Oui, Yes, YES.

Thanks so much, Bill


Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 1 guest