Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
MyOx
Frequent Visitor

Matrix with multiple culomns by multiple colomns

Hello,

 

I think i'm trying to do something simple but I cannot find how.

I have data looking like this:

 

ID

Good1Good2Good3Bad1Bad2Bad3
1x x  x
2xx   x
3  xxx 
4  x x 
5 xx x 
6 x x x
7x  x  
8xx    
9   xx 

 

And I want to show it like that

 Good1Good2Good3
Bad1111
Bad2013
Bad3221

 

 

Basicly, I want a CountIfs. How many poeple are Bad1 and Good1.

The complexity seams to come by the fact that they can have multiple Good and Bad.

 

Thanks in advance 🙂

2 ACCEPTED SOLUTIONS
lbendlin
Super User
Super User

 trying to do something simple 

ahaha. Good one. None of this is simple.

 

Here's  a version that works but at a high cost - an atrocious data model

lbendlin_0-1695773958877.pnglbendlin_1-1695773983682.png

see attached.

 

 

 

 

View solution in original post

Here is a more accurate version that also considers the non-matches.

 

 

View solution in original post

3 REPLIES 3
lbendlin
Super User
Super User

 trying to do something simple 

ahaha. Good one. None of this is simple.

 

Here's  a version that works but at a high cost - an atrocious data model

lbendlin_0-1695773958877.pnglbendlin_1-1695773983682.png

see attached.

 

 

 

 

MyOx
Frequent Visitor

Thanks you. That's what I wanted (I though it was simplier to do though 😅)

Here is a more accurate version that also considers the non-matches.

 

 

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.