Forum Discussion
Creating new table with counts of distinct values; help
Hello all, I have a table with 30 000 rows. One column in this row has a string value. There are only 40 some distinct values that can be in this column. I want to create a new table, which ...
ok so something like =SUMMARIZE(FILTER(Table1,Table1[StingValue]<>blank()),Table1[StingValue]) should work
The following worked for me;
example. Say you have a table Q3, with a column Manufacturer which repeats and you want to create a table called Manufacturers with only Distinct Manufactures and the occurrence of each
Go to "new table" under "modeling" tab
Use the expression below
Manufacturers = SUMMARIZE(Q3, Q3[Manufacturer], "Totals", COUNT(Q3[Manufacturer]))
This will create a table as below
Manufacturers Totals
Daimler 256
BMW 200