Forum Discussion

Alaska1's avatar
Alaska1
Frequent Visitor
2 years ago
Solved

Formula including blanks rows

I have a data field in Power BI on a rating scale from 0-10.  I have created a column that will mark anything <9 as a 1 and anything greater than 9 with a 0.   Measure = If(Table1[Recommend Score])...
Need Help
  • Sahir_Maharaj's avatar
    Sahir_Maharaj
    2 years ago

    Sure, can you please try this updated approach:

    Measure = 
IF(
    ISBLANK(Table1[Recommend Score]),
    BLANK(),
    IF(Table1[Recommend Score] < 9, 1, 0)
)
Sahir_Maharaj's avatar
Sahir_Maharaj
Super User
2 years ago

Sure, can you please try this updated approach:

Measure = 
IF(
    ISBLANK(Table1[Recommend Score]),
    BLANK(),
    IF(Table1[Recommend Score] < 9, 1, 0)
)
Alaska1's avatar
Alaska1
Frequent Visitor
2 years ago

Thank you.  Worked perfect.  Appreciate your help.

  • Sahir_Maharaj's avatar
    Sahir_Maharaj
    Super User
    2 years ago

    Anytime, I'm happy to help - let me know if you might have any further questions.