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] )

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
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] )

Roskalnikov's avatar
Roskalnikov
Frequent Visitor
3 years ago

Hey tamerj1

 

Thank you so much, worked a treat!