filter count with total of counts

[nrungta]

I have three columns
Distributor Name,    Invoice No.,        Month Name

Now I use a matrix table where I use my Distributor Name in Rows, Month Name in columns and DistinctCount in Values

Now supposedly each row wise the total count comes to 9 in 20 rows, 8 in 22 rows, 7 in 15 rows, and .......

How do I slice this value 9 so only 20 rows show.

Also what Calculated Column or Explicit Measure can I use.
Thank you in advance

[amitchandak]

The information you have provided is not making the problem clear to me. Can you please explain with an example. If possible please share a sample pbix file after removing sensitive information.
Thanks.

My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/Winner-Topper-on-Map-How-to-Color-States-on-a-Map-wi...
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

[nrungta]

I have attached a screenshot of the above problem, now it should hopefully give a clear meaning to the problem I am facing.
PS- I have changed the Distributor name to distributor code.

[v-gizhi-msft]

Hi,

According to your description, i create a table to test:

Choose a matrix visual, and it shows:

Then, i create a calculated table:

Slicer = SUMMARIZE('Table','Table'[Distributor Code],"Slicer",COUNTROWS('Table'))

And it shows:

Then, manage their relationship as one to many:

Now, choose column [Slicer] as a slicer visual, and it shows:

Best Regards,

Giotto Zhi

[nrungta · Accepted solution]

Hi,
  I cant tell you how much I love you for this. 
In the DAX Code

SUMMARIZE('Table','Table'[Distributor Code],"Slicer",COUNTROWS('Table'))

 I changed it to 

SUMMARIZE('Table','Table'[Distributor Code],"Slicer",distinctcount('Table'[Month]))

and then I got the desired answer. The invoices contain row-wise entry of individual items.

I have a further addition to this query now, 
suppose there was another column of Brands
and I wanted this whole table slicer to be based of only one brand, then what should i do?
please help me again thank you.
@v-gizhi-msft 

[v-gizhi-msft]

Hi,

For your requirement, please move your 'Brand' column to page filter field, and it shows:

Best Regards,

Giotto Zhi