Countrows with creating pivot table

Question

I have table from screenshot and want to recieve something like this:&nbsp;ID&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;IN&nbsp; &nbsp; &nbsp; &nbsp;OUT534303&nbsp; &nbsp; &nbsp; 8&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;061486&nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;81010454&nbsp; &nbsp; 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;02018139&nbsp; &nbsp; 7&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4etc...&nbsp;I've tried to create another table with distinct values from one of this columns, but then I can't create two active relationships with the first table

mfelix · Accepted Answer

Hi&nbsp;wicker,&nbsp;I don't understand completly the question please explain me the following.&nbsp;Your two columns are filled with the same numbers correct?The result below means that the 1010454 is 3 times in the first columns and 0 times in the second columnID&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;IN&nbsp; &nbsp; &nbsp; &nbsp;OUT1010454&nbsp; &nbsp; 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0If this is the case the easist way is to unpivot both columns and then make a visual table based on the&nbsp;attribute column:&nbsp;See attach PBIX file with example.&nbsp;Regards,MFelix&nbsp;&nbsp;

Forum Discussion

Countrows with creating pivot table

2 Replies

Related content

Pivot issue

Pivot / Unpivot?

COUNTROWS

Create pivot table visual

Created Avg Price measue without pivoting table