Use and on page table to filter a table

[shargett]

So I am new to Power Bi, and I have what is probably a very easy to solve issue, but it is evading me. I have a sharePoint list that I am using for data. The list has a question column called "pass?" The Pass column is a choice column with Yes and No as choices. I have created a Power Bi page, and added a number of chrts to display various information from this list. I added a table to the column and added the CY (Calendar Year) column. This column works very well to filter the 3 charts I have on the page. No I need to show the number of pass and fails for the year(s) selected. 

To get the count I created 2 new columns. One for Pass, and one for Fail. Here is the code I used for the Pass column "

Pass = COUNTROWS(FILTER('KMI Results Tracker', 'KMI Results Tracker'[Pass?] = "Yes"))" I also created a column to count the fails. It uses the same code for pass, but replaces Yes with No. I added a new table to the page, and added the pass and fail columns. They do properly count the number of passes and fails. Howeer, this is a total count, and is not filtered based upon the CY tablke I created earlier.

What I need is for my Pass Fail tallies to be filtered like the charts on the CY table.

Any of the chart contents and the CY table can be used to filter by simpoly selecting an object be it a bar titel or cy, and the other charts ans CY table are filtered. In a perfect world the Pass Fail would also be included in this relationship, and could be clicked to higlight passed or failed entries.

[Anonymous]

Hi @shargett ,

Please try to create a measure instead of a column.

Please refer to this for the difference between a metric and a column.

Pass Measure =COUNTROWS(FILTER(ALLSELECTED('KMI Results Tracker'),'KMI Results Tracker'[Pass?]="Yes"))

Fail Measure =COUNTROWS(FILTER(ALLSELECTED('KMI Results Tracker'),'KMI Results Tracker'[Pass?]="No"))

If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.

Best Regards,

Neeko Tang

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