Forum Discussion
Solved
Data modeling for power BI
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...
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.
sdjensen
Solution Sage
Solution SageHi,
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)