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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.