Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
5 years ago

BLANK DATA

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 😞

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    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))

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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.