How to show a value without slicer

[Anonymous]

Hey there;

I need to find a way for the matrix to show the count results without respecting the slicer

Example below;

[v-joesh-msft · Accepted solution]

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.

[Anonymous]

It works perfectly. Thank you.