Most RecentNewestMost VotedMost Viewedcount or hasone value hello there, Sometimes count, distinct count or has one value do not detect certain rows, may I know the reason. please check below highlighted CALCULATE( DISTINCTCOUNT(Z_Municipal[OrgName])) HASONEVALUE(Z_Municipal[OrgName])