Forum Discussion

MSemenoff's avatar
MSemenoff
New Member
10 years ago
Solved

Eliminating a blank from a table visualization

I'm new to DAX. I'm creating a measure using two two tables. The "one to many" relationship between the tables stems from columns of unique IDs. However the "one" side column is a subset of the "many...
Need Help
  • greggyb's avatar
    greggyb
    10 years ago

    You can filter the table using visual-, page-, or report-level filters to exclude blanks from the one side.

     

    Or you can rewrite your [Amt1] measure to do the same:

    Amt1 =
CALCULATE(
    SUM( '<many side table>'[Amount] )
    ,NOT( ISBLANK( '<one side table>'[ID] ) )
)
greggyb's avatar
greggyb
Resident Rockstar
10 years ago

You can filter the table using visual-, page-, or report-level filters to exclude blanks from the one side.

 

Or you can rewrite your [Amt1] measure to do the same:

Amt1 =
CALCULATE(
    SUM( '<many side table>'[Amount] )
    ,NOT( ISBLANK( '<one side table>'[ID] ) )
)
Anonymous's avatar
Anonymous
Not applicable
7 years ago

What if you want to include the blank in the total calculation but not as a row in the visualisation?