Forum Discussion

Saxon202202's avatar
Saxon202202
Helper III
3 years ago
Solved

Matrix table using multiple column

Hi, I have data data table and the table contain country id, country code and qty.   In visualisation, I like to breakdown by country id, country code and qty in matrix table. At the moment all...
Need Help
  • danextian's avatar
    danextian
    3 years ago

    Hi Saxon202202 

    I've edited the PBIX with a calculated column to rank Country Code by Country ID.

    Index = 
RANKX (
    FILTER ( DATA, DATA[COUNTRY ID] = EARLIER ( DATA[COUNTRY ID] ) ),
    DATA[COUNTRY CODE],
    ,
    ASC,
    DENSE
)
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi  ,

This can be resolved using switch function

SWITCH = 

SWITCH(
    TRUE(),
    SELECTEDVALUE(DATA[COUNTRY ID]) = "RS",SELECTEDVALUE(DATA[COUNTRY CODE]),
    SELECTEDVALUE(DATA[COUNTRY ID]) = "PD",SELECTEDVALUE(DATA[COUNTRY CODE]),
    SELECTEDVALUE(DATA[COUNTRY ID]) = "OQ",SUM(DATA[ORDER QTY])
)



 

BR

Saxon202202

  • Saxon202202's avatar
    Saxon202202
    Helper III
    3 years ago

    Anonymous @, Thanks for your reply. The country id should be show the relevant country code.