Forum Discussion

Handyy's avatar
Handyy
New Member
3 years ago
Solved

Matrix about counting how many specific values in column

Hello,   I'm trying to create a Matrix from data that has specific values of 5,2,1,0 and would like to show how many of those values are in each, but no matter how I try to put the columns in the M...
Need Help
  • bhelou's avatar
    bhelou
    3 years ago

    Dear , 
    Attached the file i created  , there are the steps you should do in power queries : 

    1- You need to Unpivot the table 
    2- Duplicate the new table created 
    3- remove the columns and make the Distinct column as unique ( remove duplicates ) 
    4- Relationshim ( one to many ) 
    5-in Matrix table just drag and drop the values and make it as count .

    Hope this helps , accept as a solution . Thanks 

     https://drive.google.com/drive/folders/1q_JILK5iNnwDkNU_uiS2n4nO16KthG2b?usp=sharing 


bhelou's avatar
bhelou
Responsive Resident
3 years ago

Dear , 
Attached the file i created  , there are the steps you should do in power queries : 

1- You need to Unpivot the table 
2- Duplicate the new table created 
3- remove the columns and make the Distinct column as unique ( remove duplicates ) 
4- Relationshim ( one to many ) 
5-in Matrix table just drag and drop the values and make it as count .

Hope this helps , accept as a solution . Thanks 

 https://drive.google.com/drive/folders/1q_JILK5iNnwDkNU_uiS2n4nO16KthG2b?usp=sharing 


bhelou's avatar
bhelou
Responsive Resident
3 years ago

 

 

  • Handyy's avatar
    Handyy
    New Member
    3 years ago

    Thank you, unpivoting the column was the thing I didn't realize!