Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How to display two calculated columns in matrix

Hi Team,

 

Could you please help me on below scenorio.

I have created the DAX function by using SWITCH function.please find the DAX column below.

When i use below calculation in Matrix, its summing up the values as State level and giving it in one column, but i need it in two columns, like Florida and Books combination value as one column and Florida and Chairs combination value as in different column.

Dataset

 

Formula

Measure1 = SWITCH(TRUE(), Table[State] = "Florida" && Table[Category] = "Books" , Table[Sales]),

Table[State] = "Florida" && Table[Category] = "Chairs" , Table[Sales])

 

When i use above formula it is giving result like below.

 Florida
Measure1300

 

But i require something like this.(Column names just for reference)

 Florida+BooksFlorida+Chairs
Measure1100200

 

Kindly help me with this requirement.

Need Help
  • Mariusz's avatar
    Mariusz
    6 years ago

    Hi Anonymous 

     

    Not sure if I understand your requirement but I think you can create an extra column in your table that concatenates state and category and later use it as Matrix column.

    New Column = table[state] & "-" & table[Category]

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn

     

2 Replies