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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
Sarencibia
Frequent Visitor

Many thanks!!! Thank you very much, it has worked perfectly! 💜

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors