Show current week if not filter selected

[Anonymous]

Hi, I have a table with weekly data,

when the week slicer is not filtred then show current week but otherwhise show value from week slicer.

Thanks for helping.

[Anonymous]

Like this when nothing is filtred:

and like this when is filtred:

Thanks for all help.

[v-zhangti · Accepted solution]

Hi, @Anonymous 

You can try the following methods.

Measure = 
SWITCH ( TRUE (),
    COUNTROWS ( ALLSELECTED ( 'Table'[Week Number] ) ) = COUNTROWS ( ALL ( 'Table'[Week Number] ) )
        && WEEKNUM ( TODAY (), 1 ) = SELECTEDVALUE ( 'Table'[Week Number] ), 1,
    ( COUNTROWS ( ALLSELECTED ( 'Table'[Week Number] ) ) = COUNTROWS ( ALL ( 'Table'[Week Number] ) )
    ) = FALSE (), 1
)

No filtering:

After filter:

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous ,  Try a measure like, Assuming you are using date table

if(isfiltered(Date[Week]), Sum(Table[Values]), calculate(Sum(Table[Values]), filter(Date, Date[Week] = )year(today())*100 + weeknum(today()) ) )

[Anonymous]

Hi Thanks you for your reply but its not working, Its still show all values when is not filtered, my goal is when is not filtred the table only show current week and if filtred show selected weeks of data.