Forum Discussion
lock total
dears,
good day!!
in the table below, how would i lock the total when apply filter to capture the right %
Hi 160475 ,
otherwise you can use a slicer to filter the total.
See my pbi file
https://1drv.ms/u/s!Aj45jbu0mDVJizenkeuDoIetBu-J?e=7BUwR1
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
ok look at the 2 tables below : the one in the left side is a table without anyfilter the total 23643 and the table in the right side its the same but with filter WT_mns < than 14 so total is 16844 . what i want is the total from the table in the left side to be the total in the right side
Hi 160475 ,
you can apply the filter directly in the measure and it works
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi 160475 ,
otherwise you can use a slicer to filter the total.
See my pbi file
https://1drv.ms/u/s!Aj45jbu0mDVJizenkeuDoIetBu-J?e=7BUwR1
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
