Summarizecolumns with filter from outsid summarizecolumns

[Anonymous]

HI,

I need to create two measures one for weeknum-1 and type="mouse", and one for weeknum-1 and all types

The first one comes out ok

VAR mouse_week_earlier =
CALCULATE (
DISTINCTCOUNT ( ITSM[Name] ),
FILTER (
itsm,
ITSM[Type] = "mouse"
&& WEEKNUM ( [Date], 2 )
= WEEKNUM ( MAX ( [Date] ), 2 ) - 1
)
)

With the second one I have a problem

VAR Status_week_earlier_zli =
filter(SUMMARIZECOLUMNS(ITSM[Status], "Status"
,DISTINCTCOUNT(ITSM[Name]))
&& WEEKNUM ( [Date], 2 ) = WEEKNUM ( MAX ( [Date] ), 2 ) - 1

)

)

[Anonymous · Accepted solution]

Okay, I got it.
Maybe it will be useful to someone.

VAR all_status_week_earlier =

CALCULATE (

DISTINCTCOUNT ( ITSM[Nme)] ),

FILTER (

itsm, WEEKNUM ( ITSM[Date], 2 )

= WEEKNUM ( MAX ( ITSM[Date] ), 2 ) - 1

))