Report Builder - Row Total for multiple filtered datasets

Question

Hi - I am using Report Builder to create a paginated report from multiple tables that have a filter on each dataset.&nbsp; I need to display the total number of records for all row groups. I have a column that uses an expression to show RowNumber but I only want to display the last one.&nbsp; Is there a better way to do this?&nbsp; I cannot use Rowcount due to the dataset filters.&nbsp;

v-janeyg-msft · Answer

Hi,&nbsp;3treepoint&nbsp;
What do you mean by 'display the last one' ?&nbsp;What does your visual look like?

3treepoint · Answer

I would like the last value at the bottom of the report to display (in the last column named Running Case Total), not the others above in the same column.&nbsp; See image.&nbsp;

v-janeyg-msft · Answer

3treepoint&nbsp;
&nbsp;
It seems difficult, beacuse I am not good at writing report builder code, it is difficult to help you. Can you share your expression?&nbsp;If you can add some conditions to the expression, maybe it's possible.&nbsp;
&nbsp;

Best Regards,

Community Support Team _ Janey

3treepoint · Answer

The expression is simply RowNumber(Nothing)Is it possible to change the expression so the font and background are white on all row numbers except the last one?

v-janeyg-msft · Answer

3treepoint&nbsp; The code should be impossible to change the font color and background.
If you can add a index column and modify the expression like: when index=max index, RowNumber().
&nbsp;

Best Regards,

Community Support Team _ Janey

Forum Discussion

Report Builder - Row Total for multiple filtered datasets

5 Replies

Related content

Multiple Years Filter

Filter dataset based on multiple inputs(Strings).

DAX FILTER with multiple criteria

CALCULATE with multiple filters

Multiple Filters (COUNTROWS)