Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Filled Cell Count Help Required

Hi there.   I am new to PowerBi and stuck on a DAX formula.   Basically in my table,  I have 3 columns that refer to 3 different answers from an individual in a survey. I want to create a 4th col...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , a new column in dax

    if(isblank([column1]),0,1) + if(isblank([column2]),0,1)+if(isblank([column3]),0,1)

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , a new column in dax

if(isblank([column1]),0,1) + if(isblank([column2]),0,1)+if(isblank([column3]),0,1)

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thank you sooooo much!!!:D