Aggregation issue while using field parameters.

[Anonymous]

I have created a table using field parameters(Campaign Name, Site Name, Media Buy Name) named "Dimensions" & I have also created one more table named "Measurement" consisting of Impressions, Clicks and CTR. I have added both the Field Parameters("Dimensions", and "Measurement") as Slicer on the Canvas. Following is the Data set I am using.

Campaign Name	Site Name	Media Buy Name	Impressions	Clicks	CTR
Campaign Name 1	Site Name 1	Media Buy Name 1	21	12	0.44 %
Campaign Name 1	Site Name 1	Media Buy Name 2	24	98	0.70 %
Campaign Name 1	Site Name 2	Media Buy Name 3	67	4	0.19 %
Campaign Name 2	Site Name 3	Media Buy Name 21	45	12	0.21 %
Campaign Name 2	Site Name 1	Media Buy Name 22	67	24	0.52 %
Campaign Name 2	Site Name 1	Media Buy Name 23	89	8	0.22 %
Campaign Name 2	Site Name 1	Media Buy Name 24	34	0	0.00 %
Campaign Name 3	Site Name4	Media Buy Name 31	54	8	0.03 %
Campaign Name 3	Site Name 2	Media Buy Name 32	23	10	0.03 %

I have added both field parameters in a table visual. Now the problem that I am facing is when I choose Values from "Measurement" it is not summarizing data. For example If I have selected "Campaign Name" from "Dimensions" Slicer and "Impressions" from "Measurement" Slicer. This is the result I am seeing.

Campaign Name	Impressions
Campaign Name 1	21
Campaign Name 1	24
Campaign Name 1	67
Campaign Name 2	45
Campaign Name 2	67
Campaign Name 2	89
Campaign Name 2	34
Campaign Name 3	54
Campaign Name 3	23

Below is the desired result.

Campaign Name	Impressions
Campaign Name 1	112
Campaign Name 2	235
Campaign Name 3	77

[MarceloVieira]

Reusing this topic. 

Is there any way to count the number of rows for the desired result?? It could have a million+ rows on large models, and i would like to show the number of rows to the user (dynamically), since a published report has a limted 150k rows per export.

Without using field parameter i could count the rows with:

countrows( summarize( fact_table, dim[column),dim[column),dim[column),dim[column),etc) ), where i would have all the DIM columns on a "table visual" and this measure i would use on a "card visual".

[MarceloVieira]

Anyone?? is it possible to count the number of summarized rows from dimensions, on a TABLE VISUAL using field parameters?

[MarceloVieira]

Hello, did anyone had the same necessity to counting the number of rows on a summarized "table visual" with column of several dimensions??? We have exporting dashboards published on premium, and because of the 150k rows limit in  exporting the summarized data, we need to show to "number of selected rows" to the end user.

[MarceloVieira]

@Anonymous 

It seens to work fine with measures!!

[MarceloVieira]

+1, i was posting the exactly same question.