Hello, probably a simple solution.
I've brought in data from an Access database into my data model. I'd like to count the number of text values in a particular column. I've filtered the column to only include the values I want to track. At the bottom, the Record Count is 254, the correct number. But when I create my measure it counts 319, the unfiltered number. Type is a text value, so not sure my calculation is even correct. Thanks for any help.
#Proc:=if(isblank(counta('Procall'[Type])),0,counta('Procall'[Type]))
I've brought in data from an Access database into my data model. I'd like to count the number of text values in a particular column. I've filtered the column to only include the values I want to track. At the bottom, the Record Count is 254, the correct number. But when I create my measure it counts 319, the unfiltered number. Type is a text value, so not sure my calculation is even correct. Thanks for any help.
#Proc:=if(isblank(counta('Procall'[Type])),0,counta('Procall'[Type]))