seeing your data in pbix will help otherwise what you provided in Excel is working as expected. Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!! Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBI...
Sorry @v-xicai, but it is still not working. It only gave returned a value of 1 for a single patient. I also tried Cavities Needing Filled Test = CALCULATE( COUNT('Data'[PROC_LOGIDDB]), Data[ADACODE] >= "D2140" && Data[ADACODE] <= "D3999" || Data[ADACODE] = "...
Sorry @v-xicai, but it is still not working. It only gave returned a value of 1 for a single patient. I also tried Cavities Needing Filled Test = CALCULATE( COUNT('Data'[PROC_LOGIDDB]), Data[ADACODE] >= "D2140" && Data[ADACODE] <= "D3999" || Data[ADACODE] = "...