Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Pivot DAX Column or Help with Matrix

Hi,   I have a table of Leads that basically has this structure: Category Company A Com1 A Com1 B Com2 A Com5 B Com1 C Com2 C Com4 A Com3 B Com1 My actu...
Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    6 years ago

    Anonymous ,

     

    What I can come out is to create three calculate tables like pattern below and create three table visuals though the duplicate values will be removed.

    NewTableA = SELECTCOLUMNS(FILTER('Table', 'Table'[Category] = "A"), "A", 'Table'[Company])   

NewTableB = SELECTCOLUMNS(FILTER('Table', 'Table'[Category] = "B"), "B", 'Table'[Company])     

NewTableC = SELECTCOLUMNS(FILTER('Table', 'Table'[Category] = "C"), "C", 'Table'[Company])

      

     

     

    Community Support Team _ Jimmy Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yuta-msft's avatar
v-yuta-msft
Community Support
6 years ago

Anonymous ,

 

What I can come out is to create three calculate tables like pattern below and create three table visuals though the duplicate values will be removed.

NewTableA = SELECTCOLUMNS(FILTER('Table', 'Table'[Category] = "A"), "A", 'Table'[Company])   

NewTableB = SELECTCOLUMNS(FILTER('Table', 'Table'[Category] = "B"), "B", 'Table'[Company])     

NewTableC = SELECTCOLUMNS(FILTER('Table', 'Table'[Category] = "C"), "C", 'Table'[Company])

  

 

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.