Forum Discussion
medwards
3 years agoFrequent Visitor
Help with ISBLANK function
Hope someone can help with this ISBLANK function: # Tables with no person assigned = CALCULATE(DISTINCTCOUNT(responsibility[table_id]),(responsibility[role_id]="Engineer" && ISBLANK(responsibilit...
amitchandak
3 years agoSuper User
medwards , seem fine, need data to test
Try like this
# Tables with no person assigned = CALCULATE(DISTINCTCOUNT(responsibility[table_id]),Filter(responsibility, responsibility[role_id]="Engineer" && ISBLANK(responsibility[user_id])))
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.