BLANK DATA

[Syndicate_Admin]

Hello everyone, I have been presented with a very particular case. contextualize a little:

I have a column called Adults, when I start by observing that this column is formatted as "Text" so I decide to change it to Integer.

According to, I proceed to highlight the sum of Adults that are in the table SUM (Table [adults]), but when performing the Sum gives me 0, I tried to calculate the number of adults -Calculate (CountA (Table [Adults]), Table [adult]> 0), the result is White,

I tried Calcualte (Table [Adult]), It gives me a tip but it is not the real one. in the excel table corroborates that the amount or count is 500 and with the formula exposed gives me 200. I don't know what could be going 😞

[V-pazhen-msft]

@Syndicate_Admin 

I guess you are creating measures, try add all(table) to the context, as well as for the sum.

Calculate (CountA (Table [Adults]), Filter (All(table), Table [adult]> 0)

calculate (SUM (Table [adults]),All(Table))

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Syndicate_Admin ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Try like

countrows(Filter(Table, Table [adult]> 0))

or

countrows(Filter(Table, isblank(Table [adult]) || Table [adult]<> 0))