Forum Discussion
table.group
Can you clarify - do you have 1,700 unique sectors? Or does your table have 1,700 rows of data, with 358 unique values?
Sorry if this seems like a patronising question, I just can't think of another way to explain it, based on such a small sample of data.
My data is at booking date level and has in total 26000 records, in which I have 1700 unique sectors.
I am trying to get the sum of sales for each of these 1700 sectors by grouping at sector level. Ideally in the result I should get 1700 rows but I am getting the results only for 358 sectors.
The data I gave is the sample of the results.
Hope it is clear now.
Hi lavanyak
Unfortunately, without seeing the actual data it is not possible to say why you are getting fewer unique values than you expect. All I can really suggest right now is to double-check that you are grouping by the right columns. Perhaps take the data into Excel and do some counts in there?
Sorry - I realize this is not particularly helpful!
Thanks for your response.
I crossed checked the data, using the same table if I group sales by sector in Power bi desktop visualization, I am getting total sales for all 1700 sectors.
I dont understand why I am not getting it in power query.