Skip to main content
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Sarencibia
Frequent Visitor

NEED HELP. Change a Measure into a Column

Dear community,

 

I really hope you are able to help me solve this problem.

 

I have a Measure:

 

Measure=

Var a=
MAXX(
FILTER(ALL(Table),Table[Column1]= SELECTEDVALUE(Table[Column1]) ),
Table[Column2]
)
Var b=
MAXX(
FILTER(
ALL(Table),
Table[Column1]= SELECTEDVALUE(Table[Column1])
&& Table[Column2]= a
),
Table[Column3]
)
RETURN
b

 

And I need to modify it into a column. This is possible?

Somebody could help me? Thanks!

1 ACCEPTED SOLUTION
johnt75
Super User
Super User

My Column =
VAR currentColumn1 = 'Table'[Column1]
VAR a =
    MAXX (
        FILTER ( ALL ( Table ), Table[Column1] = currentColumn1 ),
        Table[Column2]
    )
VAR b =
    MAXX (
        FILTER ( ALL ( Table ), Table[Column1] = currentColumn1 && Table[Column2] = a ),
        Table[Column3]
    )
RETURN
    b

View solution in original post

2 REPLIES 2
johnt75
Super User
Super User

My Column =
VAR currentColumn1 = 'Table'[Column1]
VAR a =
    MAXX (
        FILTER ( ALL ( Table ), Table[Column1] = currentColumn1 ),
        Table[Column2]
    )
VAR b =
    MAXX (
        FILTER ( ALL ( Table ), Table[Column1] = currentColumn1 && Table[Column2] = a ),
        Table[Column3]
    )
RETURN
    b
Sarencibia
Frequent Visitor

Many thanks!!! Thank you very much, it has worked perfectly! ๐Ÿ’œ

Helpful resources

Announcements
November Fabric Update Carousel

Fabric Monthly Update - November 2025

Check out the November 2025 Fabric update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Users online (27)