Make a measure to a calculated column?

[Anonymous]

I have the next fact:

User	Task	IsC
1	1001	0
1	1002	0
1	1003	1
1	1003	1
2	1001	0
2	1002	0
2	1003	1
2	1003	1

I have a DimUser and DimTask:

I wanted to display current Tasks for a User... I have done it as a measure but it doesnt break down by User,..

Current Tasks:=

CALCULATE (

    CONCATENATEX (

        DISTINCT ( DimTask[Task] ),

        DimTask[Task],

        ", "

    ),

    FILTER ( Fact, Fact[IsC] = TRUE )

)

How can I make it a Calculated Column?

[tamerj1]

Hi @Anonymous 

please try

Current Tasks :=
CONCATENATEX (
CALCULATETABLE (
DISTINCT ( Fact[Task] ),
ALLEXCEPT ( Fact, Fact[User] ),
Fact[IsC] = TRUE
),
DimTask[Task],
", "
)

[johnt75]

You can do it as a measure but dim user won't filter dim task, you need to involve the fact table. Try

Current Tasks :=
CALCULATE (
    CONCATENATEX ( SUMMARIZE ( 'Fact', DimTask[Task] ), DimTask[Task], ", " ),
    Fact[IsC] = TRUE
)