Forum Discussion
How to show a value without slicer
Hey there;
I need to find a way for the matrix to show the count results without respecting the slicer
Example below;
Hi Anonymous ，
You can create the following measure：
measure = IF ( ISINSCOPE ( 'Table'[Date] ), SUM ( 'Table'[Value] ), CALCULATE ( SUM ( 'Table '[Value] ), ALL ( 'Table'[Date] ) ) )
Where Date refers to the time field in the slicer, and Value refers to the Values field in the matrix.
Best Regards,
Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
v-joesh-msftSolution Sage
Hi Anonymous ，
You can create the following measure：
measure = IF ( ISINSCOPE ( 'Table'[Date] ), SUM ( 'Table'[Value] ), CALCULATE ( SUM ( 'Table '[Value] ), ALL ( 'Table'[Date] ) ) )
Where Date refers to the time field in the slicer, and Value refers to the Values field in the matrix.
Best Regards,
Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.