Using aggregations in sql query or in power bi

[akhaliq7]

If we use aggregations in our sql query side by side with non aggregated data for example the following:

id	sales	category	total_count	tvs sold by category
1	1000	tvs	4	50%
2	1100	tvs	4	50%
3	700	mobile phones	4	50%
4	600	mobile phones	4	50%

If I now bring this into power bi and I filter out id # 2 will I still be left with 50% tvs sold by company,

I am getting the data from a database using a native sql query.

What is the best practice in bringing in data into power b should the data be detailed and not summarized and to leave the summarization for power bi using measures. 

[amitchandak · Accepted solution]

@akhaliq7 , You should bring a detailed table. and try to have measures.

In some case, we bring in both detailed and summarized data to improve performance. But that will be case to case basis