Measure won't calculate for one column only

[KK12345]

Hello!

I am fairly new to Power BI and have only recently built my first full-fledged report with actual measures. Most of the measures I am using were originated by my predecessor for another report that I have reworked to fit my data source. All of my measures work with the exception of one column. I have a Form we are using to say answer Yes, No, or N/A to several different questions. My measures are written to count Yes's and divide by the count of Yes and No from the specific category to provide a percentage score. Each category has a measure and then there is an overall measure that counts all categories Yes's divided by all categories Yes and No. In the individual measure and the overall measure, this column will not calculate - it just shows 0% when it should be around 15-20%. My data source is a SharePoint and all columns in the SharePoint are the same single line of data. I've tried re-writing these in several different ways based on other answers here in the forums and non seemed to work. I've also tried transforming the data and renaming the column, as well replacing the values to be 1/0. But the calculation stays at 0%.

Any ideas on another way I can write these measures to get this column to calculate as well? Below is the individual measure, the overall measure is the exact same but counts all 15 columns Yes:

Individual Measure -

Thank you in advance, appreciate any suggestions!

[Greg_Deckler]

@KK12345 First, you could greatly simplify that measure by including all of the values "Yes and 1" in your first IN statement. And if the divisor counts every possible value, just do a COUNTROWS of the table. Difficult to know beyond that. Sample data would help. You may need to use ALL or ALLSELECTED or something depending on how your visual is configured.

Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, 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

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.