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] ) )
)
euthor's avatar
euthor
Frequent Visitor
7 years ago
The filtering tip actually worked well also for my problem, however I still don't get why I see the "blank" when I switch to the data visualisation of my PBIX file. Does anyone know how can I eliminate the blan values from each column of the data visualisation file from which the report takes all of the data? Thank you PBIX community, you are awesome!