Forum Discussion

ian_viana2's avatar
ian_viana2
New Member
3 years ago

Help with blankrows and summarize

Hi guys, I'm stuck in this measure for a while and would appreciate some help. The measure is to check if the employee filled his timesheet ( IF([Total Hours]<Measures_[Standard Hours]*.75 || ISBL...
some_bih's avatar
some_bih
Community Champion
3 years ago

Hi ian_viana2 maybe you should check your usage of ISBLANK

Check link for possible your case https://dax.guide/isblank/  as  ISBLANK check that an expression is strictly equal to BLANK

  • ian_viana2's avatar
    ian_viana2
    New Member
    3 years ago

    Hi, some_bih. In the first measure I'm using isblank to check if the measure total hours is blank or not. That's why i don't understand why the row with future dates are not counting. I tried isblank with other columns as well and it didn't work. 
    And the main thing, if the week_end_date columns is populated, why power bi is considering it as value with no data?

    the only thing i can think about is the relationship between tables, but can't figure out what.

    thanks for you help!!