Forum Discussion
Anonymous
6 years agoNot applicable
Remove row with null cells in visual
Hello everyone!
I have a matrix visual (shown below) that I have some measures applied to it. There are some empty/null cells that exist though. Is there a way to remove a row with an empty cell in the visual? Thank you!
Here are the measures used:
Before Dialog Steps =
var __BeforeDialogSteps =
SELECTCOLUMNS(
FILTER(
ST03N;
[Date Time] = [Before Date]
);
"__BeforeDIA"; [Number of Dialog Steps]
)
return
__BeforeDialogStepsAfter Dialog Steps =
var __AfterDialogSteps =
SELECTCOLUMNS(
FILTER(
ST03N;
[Date Time] = [After Date]
);
"__AfterDIA"; [Number of Dialog Steps]
)
return
__AfterDialogStepsPercentage Difference Between Checkpoints =
var __Difference = [After Dialog Steps] - [Before Dialog Steps]
return
DIVIDE(__Difference; [Before Dialog Steps])
4 Replies
- amitchandak
Super User
Anonymous , with screenshot not clear which row you want to delete
- AnonymousNot applicable
Hi amitchandak
Sorry I thought it was clear from the description. If a cell is empty in any column I would like to delete that row. So wherever you see an empty cell I want that row deleted! I hope that makes more sense.
- AnonymousNot applicable
Hi Anonymous ,
You can filter out the data with null by Filters panel:
Best Regards
Rena