Data modeling for power BI

[weilip1803]

Hi people,

I have problem with data modeling and creating new tables on Power BI,

Firstly, I have a large data set that have company name as a column and another column Test which has values a b c d e. And I want to create a new table with column A B C D e and count the total occurance that it has on the first table. How do i do that?

[ankitpatira · Accepted solution]

@weilip1803 If I understood you correctly, in power bi desktop go to query editor, right click your table and click duplicate, in duplicated table select column with values A B C D E, under Transform tab click Pivot Column, Advanced Options, Count All and this would give you a new table with columns A B C D E and count of their occurences.

[weilip1803]

Thanks so much for the solution

[sdjensen]

Hi,

Can't you just create a measure that count the rows in your table and then in a visual add column Test and your new measure?

Count = COUNTROWS(Table)