Forum Discussion
DAX to create Pivot Table
I would like to create a new Pivot Table, What DAX can make it
Orig Table
| Device | Software |
| a | s1 |
| a | s2 |
| b | s1 |
Pivot Table
| Device | s1 | s2 |
| a | TRUE | TRUE |
| b | TRUE | FALSE |
Hi Anonymous
You can create a calculated table to return the table you want .
New Table = var _summar=SUMMARIZE('Table','Table'[Device], "combine", CONCATENATEX('Table',[Software],",")) var _t=ADDCOLUMNS(_summar,"s1",IF(CONTAINSSTRING([combine],"s1"),TRUE(),FALSE()), "s2",IF(CONTAINSSTRING([combine],"s2"),TRUE(),FALSE())) return SUMMARIZE(_t,[Device],[s1],[s2])The final result is as shown :
I have attached my pbix file , you can refer to it .
Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Hi Anonymous
You can create a calculated table to return the table you want .
New Table = var _summar=SUMMARIZE('Table','Table'[Device], "combine", CONCATENATEX('Table',[Software],",")) var _t=ADDCOLUMNS(_summar,"s1",IF(CONTAINSSTRING([combine],"s1"),TRUE(),FALSE()), "s2",IF(CONTAINSSTRING([combine],"s2"),TRUE(),FALSE())) return SUMMARIZE(_t,[Device],[s1],[s2])The final result is as shown :
I have attached my pbix file , you can refer to it .
Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.- tamerj1
Community Champion
Hi Anonymous
Meaure = NOT ISBLABK ( Table[Software] ]
