The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello,
I have a dataset with a column that contains N or Y as values. I need to how how many Y , whenever it appears on the report. Issue is it rarely does and instead of seeing blank I need to see Zero. I am using the formula below. Any help is greatly appreciated.
Solved! Go to Solution.
Credit Holds = CALCULATE(COUNTA('Credit Holds'[Credit Hold]), 'Credit Holds'[Credit Hold]= "Y")+0