Issues to create a data model

[dsplaymaxxis]

Hi , I need some help to solve a problem in my job 

I need to transform the as is mentioned attached to my to be modeling .

To sum up :

I need to count how many times each status was Stored in the table above .

Count how many times the channel URA received the status "available" , "NO Info" , etc.

If the status was not part of that channel , so I would like to place the value 0 in the Tobe table .

How do I create that in DAX ou power query?

  

 

 

[dsplaymaxxis]

this is the problem by print screen

[Anonymous · Accepted solution]

HI @dsplaymaxxis,

You can do unpivoted columns on your fields to convert them to attribute and values.

Unpivot columns (Power Query) (microsoft.com)

Then you can create a matrix with 'product' and 'value' as rows, 'attribute' as the column, 'value' with count mode on the matrix value field to achieve your requirement.

Regards,

Xiaoxin Sheng