Forum Discussion

Roskalnikov's avatar
Roskalnikov
Frequent Visitor
3 years ago
Solved

Returning Dimensions with Blank Values

Hey all,   I'm trying to return a column on a table that list dimension items with blank values in related fact table. I've tried different iterations of nested ISBLANK in CALCULATE to no avail.  ...
DAX
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi Roskalnikov 

    place HN_Dim[GP Region] in a table visual then place the following filter measure in the filter pane of this table visual, select "is blank" and apply the filter 

    FilterMeasure = SELECTEDVALUE ( Services_Recieved_Fact[Services Received] )

Anonymous's avatar
Anonymous
Not applicable
3 years ago

ISBLANK() returns true/false, try BLANK()

  • Roskalnikov's avatar
    Roskalnikov
    Frequent Visitor
    3 years ago

    I've trued using BLANK() but doesn't seem to work. What would you have written as a measure?