Matrix table that displays columns with counted values

[Merabor]

Hi.

I am fairly new to PoweBi.  I am trying to create a table that shows counted values.  The columns would display a count of specifc values that are found in that column.  For example:

Language	Active Students?	Received an A on Exam	Received a B	Registered for next level	Prepaid for class
Spanish	23	4	11	19	3
French	10	6	3	8	5
Italian	19	4	6	19	19
Japanese	21	6	9	6	6

I created a Count column and added the columns that we needed the Counts from.  I have not been able to filter the count by the values of 'Yes' or 'N/A'

When i apply a filter to the column, it applies the filter to the entire visual.  

What am i doing worng?  Thank you for your time.

[v-yingjl]

Hi @Merabor ,

Based on your images, I was still not understand how it work and your expected output. For example the J39 in excel is 40, but in power bi it was 38 in one visual and 1 in another visual so that the total was 39 instead of 40 . Also I was not certain how the filter worked in the visual. Could you please share more details or share a dummy pbix file for further discussion?

Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[MarkSL]

Hi,

Are you able to share your Power Bi file (pbix) with us?  Or perhaps a mock up demonstrating your issue?  Always makes it easier for everyone to help.

Thanks

Mark

[Merabor]

@MarkSL  

My apologies.  I tried to attach an image before and it didn't give me the option to upload a photo.  Now it does 🙂

I am trying to turn the Excel document into a dashboard.  Unfortunately I cannot share the actual .pbix because of the data but please let me know if the attached image is not enough.

Thank you for your time.