Forum Discussion

y5famfnatudu's avatar
y5famfnatudu
Icon for Resolver I rankResolver I
3 years ago
Solved

Showing Ranks and their values in cards

Hello, I hope you can help me here, please. How can I show Ranks and their values in Cards? For example, I have the following table: In this report, I'm ranking only the "US" employees. ...
  • tamerj1's avatar
    tamerj1
    3 years ago

    y5famfnatudu 

    I meant all measures of each employee are in one card? However please try

    Rank1 =
    VAR ThisRank = 1
    VAR T1 =
    ADDCOLUMNS (
    VALUES ( 'Table'[Employee] ),
    "@Rank", [Rank],
    "@Revenue", [Revenue],
    "@LY", [LY]
    )
    VAR T2 =
    FILTER ( T1, [@Rank] = ThisRank )
    RETURN
    CONCATENATEX (
    T2,
    [Employee] & UNICHAR ( 10 ) & "Rank " & [@Rank]
    & UNICHAR ( 10 ) & [@Revenue]
    & UNICHAR ( 10 ) & "Revenue"
    & UNICHAR ( 10 ) & [@LY]
    & UNICHAR ( 10 ) & "LY"
    )

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

y5famfnatudu 

I meant all measures of each employee are in one card? However please try

Rank1 =
VAR ThisRank = 1
VAR T1 =
ADDCOLUMNS (
VALUES ( 'Table'[Employee] ),
"@Rank", [Rank],
"@Revenue", [Revenue],
"@LY", [LY]
)
VAR T2 =
FILTER ( T1, [@Rank] = ThisRank )
RETURN
CONCATENATEX (
T2,
[Employee] & UNICHAR ( 10 ) & "Rank " & [@Rank]
& UNICHAR ( 10 ) & [@Revenue]
& UNICHAR ( 10 ) & "Revenue"
& UNICHAR ( 10 ) & [@LY]
& UNICHAR ( 10 ) & "LY"
)

y5famfnatudu's avatar
y5famfnatudu
Icon for Resolver I rankResolver I
3 years ago

Perfect tamerj1 , that's exactly what I was looking for. Thank you so much.