Forum Discussion
Eliminating a blank from a table visualization
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] ) ) )
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] ) )
)- Thank you. I'll try both suggestions. Lots to learn.
The report level filter did the trick. The measure gave the grand total. Not sure why, maybe becuse the columns had no blanks.
Anyway, you suggestion worked. Thanks agian
greggyb This is exactly what I needed :D thanks
Hello,
So what if the Amt1 is blank? Is there a way to do this in DAX? There's a suggestion in another thread to use the Visual Filter, but the Visual Filter appears to break if for example you have a bar graph and there is a hierarchy to drill down. The lower level will work with filtering out blanks but appears to break if you drill up.
Adam
- 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!
What if you want to include the blank in the total calculation but not as a row in the visualisation?
